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)
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort: Gedurende 2024 worden GitHub Issues uitgefaseerd als het feedbackmechanisme voor inhoud. Dit wordt vervangen door een nieuw feedbacksysteem. Ga voor meer informatie naar:Feedback verzenden en bekijken voor