Applies to: SQL Server (all supported versions)
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.|
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 has been granted some permission. For more information, see Metadata Visibility Configuration.