Logo 
Search:

SQL Server Articles

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

fn_trace_getfilterinfo Function

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

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

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 (=, <>, <, >, <=, >=, LIKE, or NOT LIKE).

Value

sql_variant

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 

SELECT *
FROM    ::fn_trace_getfilterinfo(trace_id)
  
Share: 

 
 
 

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!