Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Viewing DDL Trigger Metadata by querying sys triggers

3> 4> SELECT name TriggerNM, is_disabled 5> FROM sys.triggers 6> WHERE parent_class_desc = 'DATABASE' 7> ORDER BY OBJECT_NAME(parent_id), name 8> GO TriggerNM          is_disabled ------------------------------------------------------------------------------------------------------------------------ -------- ----------- db_trg                    0 1>