Export (0) Print
Expand All
Expand Minimize

sys.server_event_notifications (Transact-SQL)

Updated: 5 December 2005

Returns a row for each server-level event notification object.

Column name Data type Description

name

sysname

Server event notification name. Is unique across all server-level event notifications.

object_id

int

Object identification number. Is unique within the master database.

parent_class

tinyint

Class of parent. Is always 100 = Server.

parent_class_desc

nvarchar(60)

Description of class of parent. Is always SERVER.

parent_id

int

Is always 0.

create_date

datetime

Date created.

modify_date

datetime

Date object was last modified by using an ALTER statement.

service_name

nvarchar(256)

Name of the target service to which the notification is sent.

broker_instance

nvarchar(128)

The service broker where the named target service is defined.

creator_sid

varbinary(85)

SID of the login executing the statement that creates the event notification. NULL if WITH FAN_IN is not specified in the event notification definition.

principal_id

int

ID of the server principal that owns this.

Release History

5 December 2005

Changed content:
  • Changed creator_id column to creator_sid, moved the column to appear after broker_instance, and clarified that this column is NULL if WITH FAN_IN is not specified in the event notification definition.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft