Friday, April 26, 2013

What Port is Named Instance of SQL Server Listening On?

exec xp_readerrorlog 1 , 1 , N'listen' It works on 2008 and lower, is said to work on 2012. exec xp_readerrorlog [log #, 1 is current] , [1 – sql server log, 2 – agent log, 3 – full text log] , [search string] http://mssqlwiki.com/2011/02/13/beyond-xp_readerrorlog/

No comments: