June 19, 2008 at 6:32 am
Can any body tell how to find the server name and IP address.
ex: server name - stwserver10 and IP is 10.10.7.45
how to find the above servername and ip
June 19, 2008 at 6:41 am
Are you logged onto the server - the servername will be the computer name found under control panel > system.
Once you have the name you can ping the name from a cmd prompt and that will give you the IP address
You could look at ipconfig from a command prompt - that should give at least the ip
Gethyn Elliswww.gethynellis.com
June 19, 2008 at 6:54 am
in SSMS you can run
select @@servername
June 19, 2008 at 7:59 am
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105157
N 56°04'39.16"
E 12°55'05.25"
June 19, 2008 at 8:08 am
Peso (6/19/2008)
See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105157
A lot of servers will have xp_cmdshell turned off for security reasons.
June 23, 2008 at 1:09 am
sory for the late reply...
I have tried @@servername, it is giving servername but how can I get ip address?
I want to find out the IP thru stored procedue...
Nagesh
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply