Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dan Guzman Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series) RE: Stairway to Server-side Tracing - Step 2: Creating a SQL Trace Using T-SQL (Stairway Series)

  • February 23, 2011 at 9:03 pm

    #1290717

    Hi, Toby.

    I also wish sp_trace_create had an option to overwrite an existing file. I'm not a big fan of file manipulation in T-SQL either.

    You might consider making a habit of the TRACE_FILE_ROLLOVER (option 2) with a file count of 2, even if you only need a single file for a one-time trace. This way, SQL Trace will add the incremental number to the file name if the base file name already exists and automatically delete the n-2 file.

    I'll cover trace data and file management later in this Stairway.