SQL Server : Find SQL Server TCP Port and IP Address
1 2 3 |
SELECT @@SERVERNAME AS ServerName , local_tcp_port,local_net_address FROM sys.dm_exec_connections WHERE session_id = @@SPID |
Results :
ServerName local_tcp_port local_net_address
DEVENV\2008R2 59663 192.168.63.223
Leave a Reply