View Filter Information (SQL Server Profiler)

APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

This topic describes how to view filters on data columns for event classes by using SQL Server Profiler.

To view filter information

  1. Open a trace file, trace table, or SQL script, and on the File menu, click Properties. If you are editing a trace template or creating a new trace, skip this step.

  2. On the Events Selection tab, right-click the data column name for the filter you want to view, and click Edit Column Filter.

  3. In the Edit Filter dialog box, expand the filter comparison operators to see the assigned value for the specified criterion. Repeat Steps 2 and 3 for all columns for which you want to view filter information.


Comparison operators with assigned values are formatted bold.

See Also

SQL Server Profiler