EXEC Sp_msforeachtable
@command1="ALTER TABLE ? DISABLE TRIGGER ALL"
go
To enable them afterwards
EXEC Sp_msforeachtable
@command1="ALTER TABLE ? ENABLE TRIGGER ALL"
go
-- SQL enable all constraints - enable all constraints sql server
-- sp_MSforeachtable is an undocumented system stored procedure
EXEC Sp_msforeachtable
@command1="ALTER TABLE ? CHECK CONSTRAINT ALL"
go
