Skip to content

Latest commit

 

History

History
54 lines (45 loc) · 2.76 KB

File metadata and controls

54 lines (45 loc) · 2.76 KB
title sys.trace_events (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 08/09/2016
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
trace_events_TSQL
trace_events
sys.trace_events
sys.trace_events_TSQL
dev_langs
TSQL
helpviewer_keywords
sys.trace_events catalog view
ms.assetid e7d2c5df-0e17-4e94-9d41-d36c7ee60662
caps.latest.revision 24
author JennieHubbard
ms.author jhubbard
manager jhubbard

sys.trace_events (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

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)