Find which port SQL Server is using to establish connections

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dan Hess » Find which port SQL Server is using to...

12 posts, Page 2 of 2

««1 2

Find which port SQL Server is using to establish connections

Rate Topic

Display Mode

Topic Options

Author

Message

noelc

Posted Thursday, September 08, 2011 9:40 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, September 26, 2011 12:58 PM
Points: 99, Visits: 124

on 2K8:
xp_ReadErrorLog 0, 1, 'listening'

-- Parameters defined:
-- Parameter 1 (int), is the number of the log file you want to read, default is "0" for current log.
-- Parameter 2 (int), value of 1 reads SQL error logs, value of 2 reads SQL Server Agent logs, with a default value of 1.
-- Parameter 3 varchar (255), is a search string for the log entry, with a default value of NULL.
-- Parameter 4 varchar (255), is another search string for the log entry, with a default value of NULL

Post #1171875

GAF

Posted Thursday, September 08, 2011 10:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:05 AM
Points: 34, Visits: 257

Thank you. Good discussion started, good job.

Post #1171911

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions