Toggle table constraint checking

Turn off constraint checking on a table:

ALTER table dbo.MyTable nocheck constraint all

Turn on constraint checking on a table:

ALTER table dbo.MyTable check constraint all