sys.event_notifications (Transact-SQL)

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.

See Also

Reference

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance