Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Other Resources
fn_trace_getfilterinfo (Transact-SQL)
System Stored Procedures (Transact-SQL)
SQL Server Profiler Stored Procedures (Transact-SQL)