sys-server-event-notifications-transact-sql.md

title	sys.server_event_notifications (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	server_event_notifications sys.server_event_notifications sys.server_event_notifications_TSQL server_event_notifications_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.server_event_notifications catalog view
ms.assetid	1a83a044-3130-4551-95ca-162525846ff5
author	stevestein
ms.author	sstein

sys.server_event_notifications (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

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