How to view filter information (Transact-SQL)

How to Install SQL Server 2000

How To

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

fn_trace_getfilterinfo

System Stored Procedures (SQL Profiler Procedures)

Viewing and Analyzing Traces