Transact-SQL Reference
fn_trace_geteventinfo
Returns information about the events traced.
Syntax
fn_trace_geteventinfo ( [ @traceid = ] trace_id )
Arguments
[ @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.
Tables Returned
| Column name | Data type | Description |
|---|---|---|
| EventID | int | ID of the traced event |
| ColumnID | int | ID numbers of all columns collected for each event |
Remarks
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:
- xp_trace_geteventclassrequired
- xp_trace_getqueuecreateinfo
- xp_trace_getqueueproperties
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'