Export (0) Print
Expand All

View Filter Information (Transact-SQL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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)
    
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft