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

Question

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 1

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.