sys.server_triggers (Transact-SQL)


Updated: June 10, 2016

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 NameData TypeDescription
namesysnameName of the trigger.
object_idintID of the object.
parent_classtinyintClass of parent. Is always:

100 = Server
parent_class_descnvarchar(60)Description of class of parent. Is always:

parent_idintAlways 0 for triggers on the SERVER.
typechar(2)Object type:

TA = Assembly (CLR) trigger

TR = SQL trigger
type_descnvarchar(60)Description of the class of the object type.


create_datedatetimeDate the trigger was created.
modify_datedatetimeDate the trigger was last modified by using an ALTER statement.
is_ms_shippedbitTrigger created on behalf of the user by an internal SQL Server component.
is_disabledbit1 = 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 has been granted some permission. For more information, see Metadata Visibility Configuration.

Catalog Views (Transact-SQL)

Community Additions