SQL EXPLORER
About Me
Mohamed Faizal
Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G
View my complete profile
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment