Applies To: SQL Server 2014, SQL Server 2016 Preview
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).
Name of the trigger.
ID of the object.
Class of parent. Is always:
100 = Server
Description of class of parent. Is always:
Always 0 for triggers on the SERVER.
TA = Assembly (CLR) trigger
TR = SQL trigger
Description of the class of the object type.
Date the trigger was created.
Date the trigger was last modified by using an ALTER statement.
Trigger created on behalf of the user by an internal SQL Server component.
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.