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

Automated Trace File Collection Expand / Collapse
Author
Message
Posted Sunday, July 13, 2003 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 22, 2012 10:59 AM
Points: 4, Visits: 50
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/losmith/automatedtracefilecollection.asp


Post #14118
Posted Tuesday, July 29, 2003 1:43 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 06, 2014 3:47 PM
Points: 164, Visits: 368
This is a good article but the examples are just for testing the trace features. To set up a regular (daily) trace, the article written by Haidong Ji titled "Using SQL Trace to Audit Database Access" has better examples of the steps needed. The VBScript is nice to know, but unnecessary. The FN_TRACE_GETTABLE will automatically import all files with the same file name plus "_x" where x is a sequential number. (example trace_1.trc) Instead of scheduling a job to run every ten minutes and calling the SP_TRACE_SETSTATUS, setting the stop time on the SP_TRACE_CREATE parameter would be less costly.

Haidong Ji's article is here:
http://www.sqlservercentral.com/columnists/hji/trace.asp




Post #70370
Posted Monday, October 06, 2008 1:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, December 01, 2012 6:15 AM
Points: 132, Visits: 302
I ran the SQL script found at http://www.sqlservercentral.com/columnists/losmith/automatedtracefilecollection.asp

and get the following message when it completes:

Msg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1
Filters with the same event column ID must be grouped together.

(1 row(s) affected)

Does anyone know how to correct that script so as not to receive that message?

Thank you.

Roger
Post #581332
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse