How to turn off/on all the foreign keys and triggers in Microsoft SQL Server?

Question

It can be needed for inserting and modifying of big amounts of data.

Answer 1

Disable all FKs:

EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO

Enable all FKs:

EXEC sp_MSforeachtable @command1="ALTER TABLE ? CHECK CONSTRAINT ALL"
GO

Disable all triggers:

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

Enable all triggers:

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

Of course, note that if you had any FKs/triggers disabled prior to this, the enable script will re-enable these.