title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

sys.server_event_notifications (Transact-SQL)

rwestMSFT

randolphwest

06/10/2016

sql

system-objects

reference

server_event_notifications

sys.server_event_notifications

sys.server_event_notifications_TSQL

server_event_notifications_TSQL

sys.server_event_notifications catalog view

TSQL

sys.server_event_notifications (Transact-SQL)

[!INCLUDE SQL Server]

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.

Permissions