SQL Server Profiler - Edit Filter

Use the Edit Filter dialog box to create and modify data column filters in a trace. Click a data column name in the list and the filter criteria that is available for that data column displays in the adjacent pane. Enter the filter criteria and click OK to apply it to the selected data column. If a filter icon appears to the left of the data column name in the list, that column already has a filter configured for it.

Note

For string type data columns, the filter criteria will show as a LIKE or NOT LIKE string value. For these filter criteria, you can use wildcards as in Transact-SQL LIKE Pattern Matching in Search Conditions

See Also

Other Resources

How to: Filter Events in a Trace (SQL Server Profiler)
How to: Filter Events Based on the Event End Time (SQL Server Profiler)
How to: Filter Events Based on the Event Start Time (SQL Server Profiler)
Filtering a Trace
Filtering Traces with SQL Server Profiler

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

15 September 2007

New content
  • Added note about using wildcards with string type data columns.