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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment