sys.trace_columns (Transact SQL)

The sys.trace_columns catalog view contains a list of all trace event columns. These columns 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_column_id

smallint

Unique ID of this column.

name

nvarchar(128)

Unique name of this column. This parameter is not localized.

type_name

nvarchar(128)

Data type name of this column.

max_size

int

Maximum data size of this column in bytes.

is_filterable

bit

Indicates whether the column can be used in filter specification.

0 = false

1 = true

is_repeatable

bit

Indicates whether the column can be referenced in the "repeated column" data.

0 = false

1 = true

is_repeated_base

bit

Indicates whether this column is used as a unique key for referencing repeated data.

0 = false

1 = true

See Also

Reference

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

Other Resources

Monitoring Events

Help and Information

Getting SQL Server 2005 Assistance