Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

How to: View Filter Information (Transact-SQL)

This topic describes how to use built-in functions to view trace 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)
    
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.