SQL Server Profiler - How to filter trace to only display TSQL containing a DELETE statement?

sql-server sql-server-profiler
atconway picture atconway · Oct 26, 2011 · Viewed 14.4k times · Source

I have a SQL Trace setup to monitor all TSQL being issued to a single database. However I only care about 'DELETE' TSQL statements being issued. Is there any way I can filter to just reporting these type of statements to the profiler? Thanks!

Answer

Klaus Byskov Pedersen picture Klaus Byskov Pedersen · Oct 26, 2011

When setting up your trace, go to event selection and select only TSQL->Batch completed. Now click the column filters button and choose TextData -> Like and write %delete%. That should do it.

EDIT: Added percent signs (%) around delete because they are needed to make it work.

Related questions

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.

Read More
Where is SQL Profiler in my SQL Server 2008?

I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere. I believe I installed the SQL Server Enterprise Express/trial version? I guess it was Express and not Enterprise after all right?

Read More
What does "exec sp_reset_connection" mean in Sql Server Profiler?

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed exec sp_reset_connection SQL:BatchStarting SELECT [c].[TestID] AS [TestID], [c].[…

Read More