Tom,

Like most things MS, there are some discrepancies in the documentation which is why I went by a query. In the article listed by Phil there are some events missing just in the first Category, Service Broker. Here's how I look at the list:

SELECT

TC.name AS category,

TE.name AS event_name

FROM

sys.trace_events AS TE JOIN

sys.trace_categories AS TC

ON TE.category_id = TC.category_id

ORDER BY

TC.name,

TE.name

Then for Yelena's list, the reserved event id's do not even exist in the sys.trace_events DMV so I didn't include reserved events. There are 32 reserved event id's I didn't count, I ran this query:

;WITH cteNumbers

AS (

SELECT

0 AS N

UNION ALL

SELECT TOP 200

ROW_NUMBER() OVER (ORDER BY C.column_id) AS N

FROM

sys.COLUMNS AS C

)

SELECT

N

FROM

cteNumbers LEFT JOIN

sys.trace_events AS TE

ON cteNumbers.N = TE.trace_event_id

WHERE

TE.trace_event_id IS NULL

Which shows just which ones aren't included in sys.trace_events. There are more in 2008 and I'm sure even more in Denali.