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/
Subscribe to:
Post Comments (Atom)
1 comment:
Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I acquire actually enjoyed account your blog posts. Any way I'll be subscribing to your augment and even I achievement you access consistently quickly.
Post a Comment