How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.
Sql-server – SQL Server Profiler – How to filter trace to only display events from one database
profilersql serversql-server-profiler
Related Topic
- Sql-server – How to get list of all tables in a database using TSQL
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql – How to list all foreign keys referencing a given table in SQL Server
- Sql-server – Altering a column: null to not null
- Sql – How to get column names from a table in SQL Server
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql-server – Get size of all tables in database
Best Answer
Under Trace properties > Events Selection tab > select show all columns. Now under column filters, you should see the database name. Enter the database name for the Like section and you should see traces only for that database.