Monday, March 12, 2012

How to set SQL Profiler via command line

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