sys.events (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Column nameData typeDescription
object_idintID of the trigger or event notification. This value, together with type, uniquely identifies the row.
typeintEvent that causes the trigger to fire.
type_descnvarchar(60)Description of the event that causes the trigger to fire.
is_trigger_eventbit1 = Trigger event.

0 = Notification event.
event_group_typeintEvent group on which the trigger or event notification is created, or null if not created on an event group.
event_group_type_descnvarchar(60)Description of the event group on which the trigger or event notification is created, or null if not created on an event group.

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

Community Additions

ADD
Show: