MCTS 70-433 SQL Server Violating Constraints

In exception circumstances you may want to temporarily disable a constraint:

alter table employee NOCHECK CONSTRAINT Age_Check;     (disable)

alter table employee CHECK CONSTRAINT Age_Check;           (re-enable)