Applies to: SQL Server (all supported versions) Azure 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_id||int||Non-zero ID of the parent object.
0 = The parent class is the database.
|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.
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.