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.
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.
In SQL Server 2005 and later versions, 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.