Export (0) Print
Expand All

sys.trace_categories (Transact-SQL)

Similar event classes are grouped by a category. Each row in the sys.trace_categories catalog view identifies a category that is unique across the server. These categories do not change for a given version of the SQL Server Database Engine.

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

Column name

Data type

Description

category_id

smallint

Unique ID of this category. This column is also in the sys.trace_events catalog view.

name

nvarchar(128)

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

type

tinyint

Category type:

0 = Normal

1 = Connection

2 = Error

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

Community Additions

ADD
Show:
© 2014 Microsoft