sys.fn_trace_getfilterinfo

Description

Returns information about the filters applied to a specified trace. Returns the following information. For more information about the columns, see sp_trace_setfilter (Transact-SQL) The ID of the column on which the filter is applied. Specifies whether the AND or OR operator is applied. Specifies the type of comparison made: This feature will be removed in a future version of SQL Server.

Syntax

fn_trace_getfilterinfo ( trace_id )

Examples

Example 1

SELECT * FROM fn_trace_getfilterinfo(2) ;
GO