Tuesday, March 2, 2010

Enable / Disable All Databbase Triggers

In Sql Server 2005 we can use
sp_msforeachtable “ALTER TABLE ? DISABLE TRIGGER all”
To enable all triggers, you can use following statement
sp_msforeachtable “ALTER TABLE ? ENABLE TRIGGER all”
Posted by at
Labels:

1 comment:

  1. Faheem AhmadApril 28, 2010 at 11:09 PM

    SELECT 'ALTER TABLE ['+ SC.NAME+'].[' + PB.NAME + '] ENABLE TRIGGER ALL'
    FROM SYS.TRIGGERS T
    JOIN SYS.ALL_OBJECTS OB ON OB.OBJECT_ID = T.OBJECT_ID
    JOIN SYS.ALL_OBJECTS PB ON PB.OBJECT_ID = OB.PARENT_OBJECT_ID
    JOIN SYS.SCHEMAS SC ON SC.SCHEMA_ID = PB.SCHEMA_ID

    ReplyDelete

Subscribe to: Post Comments (Atom)