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 |
Permissions
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.