MCITP

MCITP

Tuesday, September 11, 2012

To find the port and IP address on which SQL Server is running. It works for SQL 2005/2008/200R2


select distinct local_net_address,local_tcp_port from sys.dm_exec_connections where client_net_address != '<local machine>' 

1 comment:

Followers