Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

View Filter Information (Transact-SQL)

 

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

To view filter information

  1. 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)
    

Community Additions

ADD
Show:
© 2015 Microsoft