Autostart a trace in sql server 2k

• sryan-382759

  Valued Member

  Points: 69

  More actions

  November 16, 2006 at 2:54 pm

  #153302

  Is it possible to start a trace when sql server starts?  I found xp_trace_savequeuedefinition and xp_trace_setqueueautostart for SQL 7.0, but these are no longer used in sql 2000.

• Prakash Sawant

  SSCrazy

  Points: 2173

  More actions

  November 17, 2006 at 4:33 am

  #672545

  How are you using the trace, but SP or by Profiler?

   

  ------------
  Prakash Sawant

  http://psawant.blogspot.com

• barsuk

  SSChampion

  Points: 12280

  More actions

  November 21, 2006 at 2:24 pm

  #673334

  can't you just incorporate it ( using server server side trace) into Stored proc with sp_procoption?