Skip to content

Latest commit

 

History

History
43 lines (36 loc) · 2.03 KB

File metadata and controls

43 lines (36 loc) · 2.03 KB
title sys.server_events (Transact-SQL)
description sys.server_events (Transact-SQL)
author rwestMSFT
ms.author randolphwest
ms.date 06/10/2016
ms.prod sql
ms.prod_service database-engine
ms.technology system-objects
ms.topic reference
f1_keywords
server_events_TSQL
sys.server_events_TSQL
server_events
sys.server_events
helpviewer_keywords
sys.server_events catalog view
dev_langs
TSQL
ms.assetid 996f6c9b-6426-4847-95d9-6b77541422be

sys.server_events (Transact-SQL)

[!INCLUDE SQL Server]

Contains one row for each event for which a server-level event-notification or server-level DDL trigger fires. The columns object_id and type uniquely identify the server event.

Column name Data type Description
object_id int ID of the server-level event notification or server-level DDL trigger to fire.
type int Type of the event that causes the event notification or DDL trigger to fire.
type_desc nvarchar(60) Description of the event that causes the DDL trigger or event notification to fire.
event_group_type int Event group on which the trigger or event notification is created, or null if not created on an event group.
event_group_type_desc nvarchar(60) Description of the event group on which the trigger or event notification is created, or null if not created on an event group

Permissions

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

See Also

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