Logo 
Search:

SQL Server Articles

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

fn_trace_geteventinfo Functions

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

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

fn_trace_geteventinfo returns information about the events traced.


Syntax of fn_trace_geteventinfo Function :

fn_trace_geteventinfo ( [ @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

EventID

int

ID of the traced event

ColumnID

int

ID numbers of all columns collected for each event

 



Examples of fn_trace_geteventinfo Function :

Example 1 : Form of fn_trace_geteventinfo function in select clause 

SELECT  *
FROM     ::fn_trace_geteventinfo(trace_id)
WHERE   EventID= number
  
Share: 


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

Sarita Patel
Sarita Patel author of fn_trace_geteventinfo Functions 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!