SQL Server Articles

Submit Article
Home » Articles » SQL Server » Security FunctionsRSS Feeds

fn_trace_getfilterinfo Function

Posted By: Sarita Patel     Category: SQL Server     Views: 1238

This article explains about fn_trace_getfilterinfo function in sql server with examples.

fn_trace_getfilterinfo returns information about the filters applied to a specified trace.

Syntax of fn_trace_getfilterinfo Function :

fn_trace_getfilterinfo( [ @traceid = ] trace_id )

[ @traceid = ] trace_id i
s an ID of the trace. trace_id is of type integer. The user employs this trace_id value to identify, modify, and control the trace.

Returned field



Column Name

Data Type


Column ID


The ID of the column on which the filter is applied.

Logical Operator


Specifies whether the AND or OR operator is applied.

Comparison Operator


Specifies the type of comparison made (=, <>, <, >, <=, >=, LIKE, or NOT LIKE).



Specifies the value on which the filter is applied.


Examples of fn_trace_getfilterinfo Function :

Example 1 : Form of fn_trace_getfilterinfo function in select clause 

FROM    ::fn_trace_getfilterinfo(trace_id)

Didn't find what you were looking for? Find more on fn_trace_getfilterinfo Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of fn_trace_getfilterinfo Function is from United States.
View All Articles

Related Articles and Code:

Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

No Comment Found, Be the First to post comment!