sys.server_triggers

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.

See Also

Reference

Catalog Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance