sys-event-notifications-transact-sql.md

description	sys.event_notifications (Transact-SQL)
title	sys.event_notifications (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.reviewer
ms.technology	system-objects
ms.topic	reference
f1_keywords	event_notifications_TSQL event_notifications sys.event_notifications_TSQL sys.event_notifications
dev_langs	TSQL
helpviewer_keywords	sys.event_notifications catalog view
ms.assetid	136a76ee-2b35-4418-ab46-fda2d51f7d99
author	WilliamDAssafMSFT
ms.author	wiassaf
monikerRange	=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.event_notifications (Transact-SQL)

[!INCLUDE SQL Server SQL Database]

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

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)