sys.trigger_events (Transact-SQL)
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, event_group_type, and event_group_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. |
Permissions
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.