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

;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