Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Find which port SQL Server is using to establish connections Expand / Collapse
Author
Message
Posted Thursday, September 08, 2011 9:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC 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
Posted Thursday, September 08, 2011 10:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:23 PM
Points: 34, Visits: 314
Thank you. Good discussion started, good job.
Post #1171911
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse