Tuesday, August 14, 2012

List all trace events and trace categories

SELECT s2.[category_id] AS [Category_ID] , s2.name AS [Category_Name] , s1.trace_event_id AS [Trace_Event_ID] , s1.name AS [Event_Class_name] , s4.[trace_column_id] AS [Trace_Colum_ID] , s4.name AS [Column_Name] , s4.[type_name] AS [data_Type] FROM sys.trace_events s1 INNER JOIN sys.trace_categories s2 ON s1.category_id = s2.category_id INNER JOIN sys.trace_event_bindings s3 ON s1.trace_event_id = s3.trace_event_id INNER JOIN sys.trace_columns s4 ON s3.trace_column_id = s4.trace_column_id ORDER BY s2.[category_id] , s1.name , s4.name

No comments:

Post a Comment