SQLServer 事件探查器: 如何为“ NOTLike”列筛选器指定多个值

根据以下 http://msdn.microsoft.com/en-us/library/ms175061.aspx : 上面写着“不喜欢”的关系运算子: ”指定跟踪事件数据不能与输入的文本相同。允许多个值

但是如何指定多个值呢?

33529 次浏览

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 transaction
delete from table_name where 1=2
rollback

all perfect !!! Profiler had my statement on screen