Returns information about the events traced.
fn_trace_geteventinfo ( [ @traceid = ] trace_id )
[ @traceid = ] trace_id
Is the ID of the trace. trace_id is int, with no default. The user employs this trace_id value to identify, modify, and control the trace.
|Column name||Data type||Description|
|EventID||int||ID of the traced event|
|ColumnID||int||ID numbers of all columns collected for each event|
fn_trace_geteventinfo is a Microsoft® SQL Server™ 2000 built-in function that performs many of the actions previously executed by extended stored procedures available in earlier versions of SQL Server. Use fn_trace_geteventinfo instead of:
To obtain information previously returned by the xp_trace_geteventclassrequired, for example, execute a query in the following form:
SELECT * FROM ::fn_trace_geteventinfo(trace_id) WHERE EventID= 'x'