SQL SERVER 2005 – Profiler – Only show queries from a specific database

26th November, 2008 – 4:23 pm

This was easier in 2000.  This annoyed me for ages but not enough to actually look into why I could no longer filter by Database (well not obviously!).
The trick is to click the “Events Selection” on the “Trace Properties” when you create a new trace, and check the “Show all columns” check box, then when you hit the “Column Filters” button the Database Name option will now be present!

  1. One Response to “SQL SERVER 2005 – Profiler – Only show queries from a specific database”

  2. This is a test comment.

    By Steve Morgan on Jan 21, 2009

Post a Comment