Home Forums SQL Server 7,2000 General Disable and enable trigger RE: Disable and enable trigger

  • January 21, 2009 at 7:03 am

    #930300

    To disable / enable selective triggers...

    ALTER TABLE tableName DISABLE TRIGGER triggername

    ALTER TABLE tableName ENABLE TRIGGER triggername

    To disable / enable all triggers...

    ALTER TABLE tableName DISABLE TRIGGER ALL

    ALTER TABLE tableName ENABLE TRIGGER ALL

    Use this with caution and ensure proper handling as a transaction might have disabled but an error in the script might fail to enable it back.

    Happy SQLing...