Skip to content

Latest commit

 

History

History
49 lines (43 loc) · 2.35 KB

File metadata and controls

49 lines (43 loc) · 2.35 KB
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)