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, and 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.

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

5 December 2005

Changed content:
  • Clarified which columns this view inherits from sys.events.