• Great article, looking forward for next step.

    I had a little problem when running the query - but it was easy to spot where the problem was.

    SELECT

    t.id AS TraceId ,

    path AS TraceFilePath ,

    tcat.name AS EventCategory ,

    tevent.name AS EventClassName ,

    tcolumn.name AS ColumnName

    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

    WHERE t.is_default = 1 --default trace

    AND t.status= 1 --running

    ORDER BY TraceFilePath ,

    EventCategory ,

    EventClassName ,

    ColumnName ;

    thanks