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.

See Also

Reference