9

How do I limit a SQL Server Profiler to trace only inserts, updates and deletes to a specific database?

Aki T
  • 213
  • 1
  • 2
  • 4

2 Answers2

13

You can narrow down the list by specifying DatabaseName or DatabaseID in Column Filters:

DBName DBID

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:

enter image description here

Tom V
  • 15,752
  • 7
  • 66
  • 87
George K
  • 2,306
  • 1
  • 17
  • 32
3

You can filter by database name or database id.

Use SP_trace_setfilter to filter for one database.

sp_trace_setfilter (Transact-SQL)

If you are doing from GUI (which I do not recommend, you are better off with a server side trace), click filter columns and then chose DatabaseName. See the picture below for doing it via GUI:

enter image description here

SqlWorldWide
  • 13,687
  • 3
  • 30
  • 54