Applies To: SQL Server 2014, SQL Server 2016 Preview
Returns a row for each object that is an event notification, with sys.objects.type = EN.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Event notification name.
Object identification number. Is unique within a database.
Class of parent.
0 = Database
1 = Object or Column
Non-zero ID of the parent object.
0 = The parent class is the database.
Always equals create_date.
Name of the target service to which the notification is sent.
Broker instance to which the notification is sent.
ID of the database principal that owns this event notification.
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.