Hello,
How can I set SQL Profiler to capture the logs via command line?
This is what I have:
I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.
C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
What other parameters am I missing?
Thanks!
J
Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.
Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm
No comments:
Post a Comment