Automatically Starting Profiler

• MegaCale

  SSC Enthusiast

  Points: 118

  More actions

  January 4, 2007 at 11:44 am

  #103293

  Hi.

  I was wondering if there was a way to auto start the Sql Profiler with my specific trace templates already loaded and configured.

  It is easy to start the profiler on its own using a scheduled task, but it does not populate the profiler program and run it.

  Any help would be great!

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 5, 2007 at 12:52 am

  #681398

  create a script to run sql trace, create a procedure using the script and schedule it whenever you want to run...

  http://support.microsoft.com/kb/283790

  http://www.microsoft.com/technet/abouttn/flash/tips/tips_020205.mspx

  http://msdn2.microsoft.com/en-us/library/ms190957.aspx

   

  MohammedU
  Microsoft SQL Server MVP