Thank this author by sharing:
By Ganesh Pittala, 2013/05/25
This Query is used to Find the port number or Get Port mumber SQL Server 2000 using T-SQL
Connect to the SQL Server which server you want find the port then open te query Analyser
Rename SQL server Server
Server to server backup
SERVER NAME
VM SERVER
Cloned Server
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com