Display DDL Triggers in your SQL Server Database

To display DDL Triggers in your database (SQL Server 2005/2008), use the sys.triggers catalog view as shown below:-- Database-scoped DDL triggers in the current databaseSELECT name as TriggerName, create_date as CreationDate, type_desc as [TriggerType(SQLorCLR)], is_disabled FROM sys.triggersWHERE parent_class_desc = 'DATABASE'ORDER BY nameRead more: SQL Server curry Posted via email