dbe | SQL Trace Item

SELECT DISTINCT e.name EventClassName, v.subclass_name
FROM  sys.trace_events e 
    INNER JOIN sys.trace_subclass_values v 
        ON v.trace_event_id = e.trace_event_id
    RIGHT JOIN (Select * from ::fn_trace_geteventinfo(2)) I
        ON I.eventid = E.trace_event_id
WHERE LEN(V.subclass_name) >= 3
Comments