Microsoft - Microsoft SQL Server - SQL - Constraints - Enable all table constraints

ALTER TABLE MyTable WITH CHECK CHECK CONSTRAINT ALL