snippetsqlModerate
SQL Server Profiler - How to filter trace to only display inserts, updates and deletes to one database?
Viewed 0 times
howsqlinsertsdeletesanddatabaseonefilteronlyprofiler
Problem
How do I limit a SQL Server Profiler to trace only inserts, updates and deletes to a specific database?
Solution
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:
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:
Context
StackExchange Database Administrators Q#183720, answer score: 13
Revisions (0)
No revisions yet.