Home Forums SQL Server 2005 Administering How to Create and Start SQL Server Trace Automatically RE: How to Create and Start SQL Server Trace Automatically

  • What you can is setup your trace using the Profiler GUI, you can then script out the T-SQL needed to run the profiler and use it in a sql server job, and schedule as and when you need it.

    To get the script the option can found under in the profiler GUI

    You may need seperate job/step to stop the trace to...

    Look up the neccessary SP in BOL.

    Gethyn Elliswww.gethynellis.com