sys.trace_subclass_values (Transact SQL)

The sys.trace_subclass_values catalog view contains a list of named column values. These subclass values do not change for a given version of the Microsoft SQL Server 2005 Database Engine.

For a complete list of supported trace events, see SQL Server Event Class Reference.

Column name Data type Description

trace_event_id

smallint

ID of the trace event. This parameter is also in the sys.trace_events catalog view.

trace_column_id

smallint

ID of the trace column used for enumeration. This parameter is also in the sys.trace_columns catalog view.

subclass_name

nvarchar(128)

Meaning of the column value.

subclass_value

smallint

Column value.

See Also

Reference

Object Catalog Views (Transact-SQL)
sys.traces (Transact-SQL)
sys.trace_categories (Transact SQL)
sys.trace_columns (Transact SQL)
sys.trace_events (Transact SQL)
sys.trace_event_bindings (Transact SQL)

Other Resources

Monitoring Events

Help and Information

Getting SQL Server 2005 Assistance