Q:

How to get SQL Server Profiler to show amended tables

The ASP.Net application I'm maintaining at the moment has a lot of activity in the database when ever a postback occurs. For the example I'm currently looking at, Profiler shows a mass of activity just to refresh the UI but I know its also updating a couple of tables.
What would be the best trace filter to only show the sprocs/statements that are either inserting, updating, deleting?
Is there a way to just show the table that are I/U/D (but I doubt this is possible)?
Thanks for your help on this.

A:

Try a trace on SP:Completed and RPC:Completed with column filters on TextData for:

% insert %
% delete %
% update %

Might get the odd spurious result but it'll narrow the field. Add SQL:BatchCompleted if you have a mix of procs and statements.

