sys-trace-categories-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sys.trace_categories (Transact-SQL)	sys.trace_categories (Transact-SQL)	rwestMSFT	randolphwest	08/09/2016	sql	system-objects	reference	trace_categories trace_categories_TSQL sys.trace_categories sys.trace_categories_TSQL	sys.trace_categories catalog view	TSQL

sys.trace_categories (Transact-SQL)

[!INCLUDE SQL Server]

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 [!INCLUDEssDEnoversion].

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

Important

[!INCLUDEssNoteDepFutureAvoid] Use Extended Event catalog views instead.

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

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

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