sys.server_triggers (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

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 SQL Server component.
is_disabled bit 1 = Trigger is disabled.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Catalog Views (Transact-SQL)