Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dan Hess Find which port SQL Server is using to establish connections RE: Find which port SQL Server is using to establish connections
Lawrence Moore
Ten Centuries
Points: 1203
More actions
September 8, 2011 at 2:22 am
#1378401
How about using this for a TSQL based solution?:
SELECT DISTINCT(local_tcp_port) FROM sys.dm_exec_connections
WHERE net_transport='TCP'