fn_trace_getfilterinfo (Transact-SQL)
Returns information about the filters applied to a specified trace.
Transact-SQL Syntax Conventions
Returns the following information. For more information about the columns, see sp_trace_setfilter (Transact-SQL).
| Column name | Data type | Description |
|---|---|---|
|
Column ID |
int |
The ID of the column on which the filter is applied. |
|
Logical Operator |
int |
Specifies whether the AND or OR operator is applied. |
|
Comparison Operator |
int |
Specifies the type of comparison made: 0 = Equal 1 = Not equal 2 = Greater than 3 = Less than 4 = Greater than or equal 5 = Less than or equal 6 = Like 7 = Not like |
|
Value |
sql_variant |
Specifies the value on which the filter is applied. |
The user sets trace_id value to identify, modify, and control the trace. When passed the ID of a specific trace, fn_trace_getfilterinfo returns information about that trace. When passed a 0, NULL, or the string 'default', this function returns information about all active traces. When passed an invalid ID, this function returns an empty rowset.
