Skip to content

Latest commit

 

History

History
48 lines (39 loc) · 2.52 KB

File metadata and controls

48 lines (39 loc) · 2.52 KB
title sys.trace_events (Transact-SQL)
description sys.trace_events (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 08/09/2016
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
trace_events_TSQL
trace_events
sys.trace_events
sys.trace_events_TSQL
helpviewer_keywords
sys.trace_events catalog view
dev_langs
TSQL

sys.trace_events (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

The sys.trace_events catalog view contains a list of all SQL trace events. These trace events do not change for a given version of the [!INCLUDEssDEnoversion].

Important

[!INCLUDEssNoteDepFutureAvoid] Use Extended Event catalog views instead.

For more information about these trace events, see SQL Server Event Class Reference.

Column name Data type Description
trace_event_id smallint Unique ID of the event. This column is also in the sys.trace_event_bindings and sys.trace_subclass_values catalog views.
category_id smallint Category ID of the event. This column is also in the sys.trace_categories catalog view.
name nvarchar(128) Unique name of this event. This parameter is not localized.

Permissions

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

See also

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