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

sql-server profiler
Moe Sisko picture Moe Sisko · Jun 16, 2011 · Viewed 30k times · Source

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 ?

Answer

Moe Sisko picture Moe Sisko · Jun 16, 2011

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.

Related questions

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.

Read More
Oracle: is there a tool to trace queries, like Profiler for sql server?

i work with sql server, but i must migrate to an application with Oracle DB. for trace my application queries, in Sql Server i use wonderful Profiler tool. is there something of equivalent for Oracle?

Read More
How to profile for one table in SQL Server?

How can I add a filter which can trace sql statements for a particular table name?

Read More