sys.server_triggers (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

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:

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.


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.


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

See Also

Catalog Views (Transact-SQL)