Is there a way in SQL profiler to filter by INSERT statements?

sql sql-server-profiler
user53885 picture user53885 · Mar 8, 2010 · Viewed 20.3k times · Source

I am trying to identify SQL INSERTS that occur when a record is viewed from a Windows application. In SQL Profiler I have a long list of stored procedures that fire when the record is viewed, however it is very cumbersome to identify the stored procedure then locate the inserts, then find the stored procedure in the object explorer (even with filters).

Is there a way for me to see all SQL commands on a line item instead of a stored procedure? And then filter by INSERT statements?

Thanks for any assitance!

Answer

user121301 picture user121301 · Mar 8, 2010

Try watching the events SP:StmtStarting and SQL:StmtStarting, include column TextData, and set a Column Filter for TextData with the Like set to %insert%.

This may include some false positives like references to the "inserted" table in a trigger, etc.

Related questions

How can i see what IP address made the request to SQL Server?

i need to clearly see what IP address made what sql query to SQL server. I am trying to use SQL Profiler, but it seems there is no way i can somehow to differentiate the machine (browser) where the query …

Read More
Can SQL Profiler display return result sets alongside the query?

In SQL Profiler 2005, is it possible to capture a result set in a SQL trace, so that I could see corresponding queries with result sets? ...Or is it only a one way trace? Thanks! George

Read More
SQL Server Profiler deprecation - Replacement?

I am developing ASP.NET and SQL Server applications, sometimes i am having trouble with a SQL Query, and i would like to see the SQL Servers "response" and not just the ASP.NET error message (Which is not always …

Read More