Applies to: SQL Server (all supported versions)
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.|
|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.|
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.