ansaurus

Question

How do I find out the host for the local SQL 2005 server?

Answer 1

+1 A:

Start -> Run

then type:

cmd

in a command window type:

netstat -o -a

Then switch to taskmanager and find PID of your application, so you can then search this pid in netstat output. I think there will be enough details for you.

smok1 2009-08-05 10:34:04

netstat -o -a runs very fast and the command closes within 1 sec. How could I keep it open?

Greg 2009-08-05 10:45:32

Either run it from a command prompt or use cmd /k netstat -o -a

adrianbanks 2009-08-05 10:57:21

start -> Execute -> cmdThen write netstat there and the window will not close.

Jonathan 2009-08-05 10:58:33

@Greg - use Jonathan or adrianbanks approach. I am also adding this to my reply.

smok1 2009-08-05 11:09:26

Thanx a million smok1

Greg 2009-08-05 11:46:17

Thank you Jonathan

Greg 2009-08-05 12:07:08

Thank you adrianbanks

Greg 2009-08-05 12:07:43

Answer 2

+2 A:

In command prompt type in

netstat -a

This should give you the list of all current TCP connections. You should be able to see the one connected to a server on the mssql port.

holz 2009-08-05 10:34:15

netstat -a runs very fast and the command closes within 1 sec. How could I keep it open?

Greg 2009-08-05 10:46:16

thanx a million holz

Greg 2009-08-05 11:47:36

Answer 3

+3 A:

Have you tried select host_name()?

Neil Barnwell 2009-08-05 10:36:25

ansaurus

tags:

views:

answers:

How do I find out the host for the local SQL 2005 server?

related questions