Returns a row for each object that is an event notification, with sys.objects.type = EN.
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.
In SQL Server 2005 and later versions, 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.