Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sys.events (Transact-SQL)
Collapse the table of content
Expand the table of content

sys.events (Transact-SQL)

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.

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.

Community Additions

ADD
Show:
© 2015 Microsoft