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:
SERVER.
|
|
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.
CLR_TRIGGER
SQL_TRIGGER
|
|
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.
|
Permissions
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.
See Also