Event ID

While tracing we often get eventid. This code will list all eventid:s and the explanation. (sql2005)

SELECT DISTINCT T.eventid, E.name
FROM fn_trace_geteventinfo(1) T
JOIN sys.trace_events E
ON T.eventid = E.trace_event_id
GO