Skip to main content
May 12, 2016

Working on a software project can be time consuming and it is useful if any task could be shortened or automatized.

If you often work on SQL Server you might come across a requirement to disable or enable all triggers in database.

Here are instructions how you can achiveve that:

Disable all triggers in database

exec sp_msforeachtable @command1 = 'ALTER TABLE [table_name] DISABLE TRIGGER ALL'

Enable all triggers in database

exec sp_msforeachtable @command1 = 'ALTER TABLE [table_name] ENABLE TRIGGER ALL'

Note: Keep in mind that the function sp_msforeachtable is not documented.