Post reply

SQL Profiler

  • June 24, 2005 at 9:32 am

    #110256

    How can I capture sesssions to and from a particular Database (excluding all others) in a SQL Profiler trace?

  • June 24, 2005 at 9:57 am

    #568308

    when you create the trace, in the Filter Tab select DatabaseID Like "Yourdatabase ID"

    AND check Exclude system IDs


    * Noel

  • June 24, 2005 at 12:27 pm

    #568362

    I tried that..  actually I tried filtering on  DatabaseName because DatabaseID requires a numberic value and I don't know what that is.    When I filtered on DatabaseName, it returned ALL Database connections.   not sure what I'm doing wrong.

  • June 24, 2005 at 1:12 pm

    #568378

    not sure about database name but:

    select db_id() -- gives you the number you need when runned on the desired db

     


    * Noel

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

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