title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

monikerRange

sys.event_notifications (Transact-SQL)

rwestMSFT

randolphwest

06/10/2016

sql

system-objects

reference

event_notifications_TSQL

event_notifications

sys.event_notifications_TSQL

sys.event_notifications

sys.event_notifications catalog view

TSQL

=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

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.

Permissions