-- ===================================================== ======
-- Create procedure basic template
-- ===================================================== ======
-- Creating the store procedure
If exists (Select name
From sysobjects
Where name = n' ccyt _ getip'
And type = 'P ')
Drop procedure ccyt_getip
Go
Create procedure ccyt_getip
@ Sname varchar (50)
As
If @ sname = '.'
Begin
Set @ sname =servername
End
If @ sname = 'local'
Begin
Set @ sname =servername
End
If @ sname like '%. %'
Begin
Select servername = @ sname, serverip = @ sname
End
Else
Begin
Create Table # IP (ID int identity (1, 1), Re varchar (200 ))
Declare @ s varchar (1000)
Set @ s = 'ping' + ltrim (rtrim (@ sname) + '-a-n 1-l 1'
Insert # IP (re) exec master .. xp_mongoshell @ s
Select servername = ltrim (rtrim (@ sname), serverip = stuff (left (Re, charindex (']', RE)-1), 1, charindex ('[', re ),'')
From # IP
Where id = 2
Drop table # IP
End
Go