Search code examples
sql-server-2000sql-server-profiler

SQL Server 2000 SQL Profiler filters ignored


I am not able to filter events in my database.

When creating a trace, I specify a "Database Name" in the filters tab and add my database name, "pr200".

However, the profiler seems to ignore this information and keeps showing events from all databases.

What am I missing?


Solution

  • Filter for dbid instead of dbname, seems there is a bug inside the profiler.

    Use sp_helpdb 'db_name' to find the dbid for a given database name.