About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Tuesday, July 12, 2016

Find the TCP Port number



USE master
GO
xp_readerrorlog 0, 10, N'Server is listening on'
GO


SELECT DISTINCT
    local_tcp_port
FROM sys.dm_exec_connections
WHERE local_tcp_port IS NOT NULL


No comments:

Post a Comment