DECLARE @TracePath nvarchar(256)
SELECT @TracePath = [path]
FROM master.sys.traces
SELECT *
FROM ::fn_trace_gettable (@TracePath,default)
SELECT T.EventID
, T.ColumnID
, E.Name [EventDescription]
, C.Name [ColumnDescription]
FROM ::fn_trace_geteventinfo(1) T
INNER JOIN sys.trace_events E ON T.EventID = E.trace_event_id
INNER JOIN sys.trace_columns C ON T.columnid = C.trace_column_id
SELECT T.EventID
, E.Name [EventDescription]
, COUNT(*) [DataColumnCount]
FROM ::fn_trace_geteventinfo(1) T
INNER JOIN sys.trace_events E ON T.EventID = E.trace_event_id
GROUP BY T.EventID, E.Name