sys.server_event_notifications (Transact-SQL)

Returns a row for each server-level event notification object.

Column name	Data type	Description
name	sysname	Server event notification name. Is unique across all server-level event notifications.
object_id	int	Object identification number. Is unique within the master database.
parent_class	tinyint	Class of parent. Is always 100 = Server.
parent_class_desc	nvarchar(60)	Description of class of parent. Is always SERVER.
parent_id	int	Is always 0.
create_date	datetime	Date created.
modify_date	datetime	Date object was last modified by using an ALTER statement.
service_name	nvarchar(256)	Name of the target service to which the notification is sent.
broker_instance	nvarchar(128)	The service broker where the named target service is defined.
creator_sid	varbinary(85)	SID of the login executing the statement that creates the event notification. NULL if WITH FAN_IN is not specified in the event notification definition.
principal_id	int	ID of the server principal that owns this.

Change History

Release	History
5 December 2005	Changed content: Changed creator_id column to creator_sid, moved the column to appear after broker_instance, and clarified that this column is NULL if WITH FAN_IN is not specified in the event notification definition.