View Filter Information (Transact-SQL)

This topic describes how to use built-in functions to view trace filter information.

To view filter information

• Execute fn_trace_getfilterinfo by specifying the ID of the trace about which filter information is needed. This function returns a table that lists the filters, the columns on which the filters are applied, and the values on which the filter is applied.

  Invoke the function this way:

  SELECT *
  FROM ::fn_trace_getfilterinfo(trace_id)
  

See Also

Reference

sys.fn_trace_getfilterinfo (Transact-SQL)

System Stored Procedures (Transact-SQL)

SQL Server Profiler Stored Procedures (Transact-SQL)