Skip to content

Latest commit

 

History

History
41 lines (34 loc) · 1.92 KB

sys-server-events-transact-sql.md

File metadata and controls

41 lines (34 loc) · 1.92 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.server_events (Transact-SQL)
sys.server_events (Transact-SQL)
rwestMSFT
randolphwest
06/10/2016
sql
system-objects
reference
server_events_TSQL
sys.server_events_TSQL
server_events
sys.server_events
sys.server_events catalog view
TSQL

sys.server_events (Transact-SQL)

[!INCLUDE sqlserver-asdbmi]

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)