Hi Dan,

First, thanks for the article, it's been very helpful.

I saw your earlier reply regarding the versioning, and I should have been clearer. I was referring to the missing spaces in the FROM section, which should be corrected to:

FROM sys.traces AS t

CROSS APPLY FN_TRACE_GETEVENTINFO(t.id) AS tdef

JOIN sys.trace_events AS tevent ON tdef.eventid = tevent.trace_event_id

JOIN sys.trace_categories AS tcat ON tcat.category_id = tevent.category_id

JOIN sys.trace_columns AS tcolumn ON tcolumn.trace_column_id = tdef.columnid

It's simple to correct, but the original doesn't parse in SSMS as is.

Thanks for the quick response,

Mike