start trace with sql startup

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  June 15, 2011 at 9:40 am

  #242189

  I would like to run a specific trace as a server side trace every time SQL restarts. At this point server side trace is working but stops when server restarts. This server side trace is not the default trace but another trace I have defined.

  thoughts?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 15, 2011 at 10:04 am

  #1339106

  Script the trace in a proc and then :

  http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx