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 database
SELECT name as TriggerName, create_date as CreationDate, type_desc as [TriggerType(SQLorCLR)], is_disabled
FROM sys.triggers
WHERE parent_class_desc = 'DATABASE'
ORDER BY nameRead more: SQL Server curry
SELECT name as TriggerName, create_date as CreationDate, type_desc as [TriggerType(SQLorCLR)], is_disabled
FROM sys.triggers
WHERE parent_class_desc = 'DATABASE'
ORDER BY nameRead more: SQL Server curry
Posts
0 comments:
Post a Comment