sys.event_notifications (Transact-SQL)

Returns a row for each object that is an event notification, with sys.objects.type = EN.

Column name	Data type	Description
name	sysname	Event notification name.
object_id	int	Object identification number. Is unique within a database.
parent_class	tinyint	Class of parent. 0 = Database 1 = Object or Column
parent_class_desc	nvarchar(60)	DATABASE OBJECT_OR_COLUMN
parent_id	int	Non-zero ID of the parent object. 0 = The parent class is the database.
create_date	datetime	Date created.
modify_date	datetime	Always equals create_date.
service_name	nvarchar(256)	Name of the target service to which the notification is sent.
broker_instance	nvarchar(128)	Broker instance to which the notification is sent.
principal_id	int	ID of the database principal that owns this event notification.
creator_sid	varbinary(85)	SID of the login who created the event notification. Is NULL if the FAN_IN option is not specified.

See Also