Modifiy Trace name from Server__sp_trace_1.trc to Server1.trc

Mar 21, 2011 at 1:51 PM
Edited Mar 21, 2011 at 1:52 PM

Is there a way to define the name of the .trc files that are created?  I noticed that by default the following is created server__sp_trace_1.trc.  The underscores cause a problem for me when I attempt to load the traces in to profiler using rollover.  Is there a way to eliminate the underscores in the XML script or anywhere else?

Mar 23, 2011 at 8:34 PM

This is not a SQL Nexus related question but I believe you are talking about capturing profiler trace data using SQLDIAG or PSSDIAG. If that is the case, then you would have to define a custom server side trace to generate the file names that you specify or modify the MSDiagProcs.sql which holds the sp_trace procedure which creates the server side profiler trace.