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

Turn off start/stop trace verbose in SQL server Log file Expand / Collapse
Author
Message
Posted Monday, November 16, 2009 1:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 24, 2014 10:59 AM
Points: 26, Visits: 143
hi,

Is there a way to turn off the start/stop trace verbose in SQL server Log file

here is the ouput in the Log file:
Message
SQL Trace ID 2 was started by login "CsEnv_lnrp614_prod4".
Message
SQL Trace stopped. Trace ID = '2'. Login Name = 'CsEnv_lnrp614_prod4'.

Context: we have an application that start and stop a trace every 5 min, and fill up the log file.

thanks.
Post #819656
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse