According to : http://msdn.microsoft.com/en-us/library/ms175061.aspx It says that the "NOT LIKE" relational operator : "Specifies that the trace event data must not be like the text entered. Allows multiple values."
But HOW do you specify multiple values ?
This is tricky , if you add with enter multiple in the like area this will OR them. I usally want AND. In not like area or is great , is any of the values in the rows ignored . So for example I was searching for DELETE statements on a specific table. For this in TextData
like ->
%table_name%
not like ->
%insert%
%update%
%select%
With this limiting to only delete . This is not perfect if there is a delete with a select text inside it will not run. Try to filter less and then increase your filter based on your production data.
After this tested with a
Begin transaction
delete from table_name where 1=2
rollback
all perfect !!! Profiler had my statement on screen