Post reply

Autostart a trace in sql server 2k

  • 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.

  • 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

  • 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?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply