How do I limit a SQL Server Profiler to trace only inserts, updates and deletes to a specific database?
SQL Server Profiler – Filter Trace for Inserts, Updates, and Deletes
profilersql serversql-server-2008-r2
Related Question
- Sql-server – Collecting trace info of SQL Server 2005 using SQL Server 2008 R2 profiler
- Sql-server – Logging and Replaying database updates/inserts SQL Server 2008
- Sql-server – meaning of ## in SQL Server Profiler trace data
- How to Trace Steps in SQL Profiler for a Specific Application
- Sql-server – Is this considered a “light load” trace to run on SQL Server Profiler
- SQL Profiler – Can SQL Profiler Filter Data Columns for One Event
- Sql-server – How to keep a SQL Server Profiler trace from jumping to the bottom entry
Best Answer
You can narrow down the list by specifying DatabaseName or DatabaseID in Column Filters:
Note however that you need to check the box "show all columns" first.
As for inserts, updates and deletes you can filter by text column at the same place: