Lazzycoder Code For Everyone

Have a Question?

If you have any question you can ask below or enter what you are looking for!

    Disable/Enable all triggers in an MSSQL database

    29-12-2015 17:35:40 MSSQL / Operation 0 Bookmark(s) 170 View(s)

     

    
EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL"

    To re-enable them afterwards:

    
EXEC sp_MSforeachtable @command1="ALTER TABLE ? ENABLE TRIGGER ALL"