Post reply

Profiling: How to specifiy a database?

  • May 8, 2008 at 8:11 pm

    #121982

    Hi,

    In 2000 i was able to obtain the database id with select db_id() and use this ID as a filter when running a profile trace.

    I can't seem to find where I filter on a specific database in the 2005 Query profiler program. I guess I am missing the obvious. The "Column Filters" option doesn't seem to have an option to select a specified database by ID (or any other way).

    PS. I have already filtered on username, but its not enough.

    Can someone point me in the right direction?

    Cheers,

  • May 8, 2008 at 9:01 pm

    #812784

    Scott,

    On the trace tab, second one with the events, click "Show all columns" (lower right), then when you click the button for column filters Database will be there.

  • May 8, 2008 at 9:18 pm

    #812786

    Hi,

    Thats the solution... thankyou.

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

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