sys.server_events (Transact-SQL)

Contains one row for each event for which a server-level event-notification or DDL trigger fires. The columns (object_id, type) uniquely identify the server event.

Column name Data type Description

object_id

int

ID of the server event notification to fire.

type

int

Type of the event that causes the event notification or DDL trigger to fire.

type_desc

nvarchar(60)

Description of the event that causes the DDL trigger or event notification to fire.

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance