Using xp_readerrorlog
Execute following stored procedure on the instance where you want to find out port on which SQL Server is running.USE MASTER
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO
The above query will return results something very similar to the following:
No comments:
Post a Comment