Disable/Enable All Triggers in SQL Server.


To disable Triggers Run below code.

sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER all'

To enable all triggers, you can use following statement

sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER all'

Posted in | 0 comments