Automated Trace File Collection

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 Lowell Smith » Automated Trace File Collection

Automated Trace File Collection

Rate Topic

Display Mode

Topic Options

Author

Message

lowellismith

Posted Sunday, July 13, 2003 12:00 AM

Forum 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

cppwiz

Posted Tuesday, July 29, 2003 1:43 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 8:57 PM
Points: 163, Visits: 355

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

Roger Abram

Posted Monday, October 06, 2008 1:16 PM

SSC-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 »

Permissions