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