sys-events-transact-sql.md

title	sys.events (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.events_TSQL sys.events events_TSQL events
dev_langs	TSQL
helpviewer_keywords	sys.events catalog view
ms.assetid	f245a97a-80fc-43fb-a6e4-139420c9a47a
caps.latest.revision	38
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.events (Transact-SQL)

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

Contains a row for each event for which a trigger or event notification fires. These events represent the event types that are specified when the trigger or event notification is created by using CREATE TRIGGER or CREATE EVENT NOTIFICATION.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version), [!INCLUDEssSDSfull].

Column name	Data type	Description
object_id	int	ID of the trigger or event notification. This value, together with type, uniquely identifies the row.
type	int	Event that causes the trigger to fire.
type_desc	nvarchar(60)	Description of the event that causes the trigger to fire.
is_trigger_event	bit	1 = Trigger event. 0 = Notification event.
event_group_type	int	Event group on which the trigger or event notification is created, or null if not created on an event group.
event_group_type_desc	nvarchar(60)	Description of the event group on which the trigger or event notification is created, or null if not created on an event group.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)