Menu
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 ?
762
On the File menu, click Properties. In the Trace File Properties or Trace Table Properties dialog box, click the Events Selection tab. On the Events Selection tab, click Organize Columns. In the Organize Columns dialog box, select one column by which you want to group and aggregate the displayed trace events.
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.
89
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
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
