Post reply

Limit SQL TRACE to selected a DB

  • May 11, 2006 at 11:49 am

    #366187

    Articles from 9 DB's are transactionally replicated from our SQL 2000 OLTP Server to our SQL 2000 Reporting Server.

    I have SQL TRACE(s) activated on the subscribing (Reporting) server.  The TRACEs are generating HUGE .trc files.

    Realistically  - I only want to TRACE 1 DB on the target subscribing Reporting SQL Server.  Is there a way to limit SQL TRACE to selected a DB?

    -thx

     

    BT

  • May 11, 2006 at 1:56 pm

    #637390

    Use sp_trace_setfilter in your code if you do it as a server trace. Use Database ID. I could not make Database name work as a filter, but Database ID works well.

     

    Regards,Yelena Varsha

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

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