sys.server_triggers (Transact-SQL)
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.