SQL Server Profiler : How to specify multiple values for "NOT LIKE" column filter
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.
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 transactiondelete from table_name where 1=2rollback all perfect !!! Profiler had my statement on screen