Export (0) Print
Expand All
Expand Minimize

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft