ENDPPOINT and Local TCP PORT used by SQL 2005

,

Identify Local_TCP_Portand ENDPOINT used by a SQL Connection

SELECT a.EndPoint_Id,Name,Local_TCP_Port,Client_Net_Address 
FROM SYS.DM_EXEC_CONNECTIONS a
INNER JOIN 
SYS.ENDPOINTS b
ON a.Endpoint_ID=b.Endpoint_ID

Rate

Share

Share

Rate