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:

Post a Comment