sys.event_notifications (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
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
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)