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.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" 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: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)