sys-event-notifications-transact-sql.md

title	sys.event_notifications (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-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
caps.latest.revision	26
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sys.event_notifications (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx_md]

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)