How to view filter information (Transact-SQL)
To view filter information
- Execute fn_trace_getfilterinfo specifying the ID of the trace on which filter information is needed. This function will return a table listing the filters, the column on which the filters are applied, and the value on which the filter is applied.
Invoke the function this way:
SELECT * FROM ::fn_trace_getfilterinfo(trace_id)
See Also
Creating and Managing Traces and Templates
System Stored Procedures (SQL Profiler Procedures)