Skip to content

sys-trigger-events-transact-sql.md

Latest commit

 

History

History
52 lines (45 loc) · 2.27 KB

sys-trigger-events-transact-sql.md

File metadata and controls

52 lines (45 loc) · 2.27 KB

title: "sys.trigger_events (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:

  • "trigger_events_TSQL"
  • "trigger_events"
  • "sys.trigger_events"
  • "sys.trigger_events_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sys.trigger_events catalog view" ms.assetid: 92540447-131c-491c-b033-c064c7d950e1 caps.latest.revision: 31 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

sys.trigger_events (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Contains a row per event for which a trigger fires.

Note

sys.trigger_events does not apply to event notifications.

Column name Data type Description
<Columns inherited from sys.events> Not applicable Inherits the object_id, type, type_desc columns from sys.events.
is_first bit Trigger is marked to be the first to fire for this event.
is_last bit Trigger is marked to be the last to fire for this event.
event_group_type int Event group on which the trigger 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 is created, or null if not created on an event group.

Permissions

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

See Also

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