sys-server-triggers-transact-sql.md

title	sys.server_triggers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	server_triggers sys.server_triggers_TSQL server_triggers_TSQL sys.server_triggers
dev_langs	TSQL
helpviewer_keywords	sys.server_triggers catalog view
ms.assetid	25926ff4-9271-45bf-bc32-d5d3344bd47a
caps.latest.revision	15
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.server_triggers (Transact-SQL)

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

Contains the set of all server-level DDL triggers with object_type of TR or TA. In the case of CLR triggers, the assembly must be loaded into the master database. All server-level DDL trigger names exist in a single, global scope.

Column Name	Data Type	Description
name	sysname	Name of the trigger.
object_id	int	ID of the object.
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	Always 0 for triggers on the SERVER.
type	char(2)	Object type: TA = Assembly (CLR) trigger TR = SQL trigger
type_desc	nvarchar(60)	Description of the class of the object type. CLR_TRIGGER SQL_TRIGGER
create_date	datetime	Date the trigger was created.
modify_date	datetime	Date the trigger was last modified by using an ALTER statement.
is_ms_shipped	bit	Trigger created on behalf of the user by an internal [!INCLUDEssNoVersion] component.
is_disabled	bit	1 = Trigger is disabled.

Permissions

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

See Also

Catalog Views (Transact-SQL)