Friday, March 30, 2012

Is there a sp_trace method to read input from a template file?

Is there a way to pass to template file to an sp_trace method to specify the
trace parameters to the profiler?
Thanks,
Reshma.Reshma wrote:
> Is there a way to pass to template file to an sp_trace method to
> specify the trace parameters to the profiler?
> Thanks,
> Reshma.
You can specify the following on the Profiler command-line:
/S Server
/D Database
/B Trace table to load
/E Trusted Connection
/U Login Name
/P Password
/F Trace File to load
/T Template file to load or use when starting a new trace
You can also script your own traces using the SQL Trace API (see
sp_trace* procs in BOL).
David Gugick
Imceda Software
www.imceda.com

No comments:

Post a Comment