SQL Server Profiler : How to specify multiple values for "NOT LIKE" column filter

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 ?

Solution 1:

Never mind, figured it out. After you have typed in one value, press ENTER at the end of the textbox. This causes another textbox to be shown under the current one, into which you can type an additional value.

Solution 2:

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