For a temporary fix, it's easier to instruct SQL Server to stop checking enforcing the constriant.

ALTER TABLE tablename NOCHECK CONSTRAINT constraintname

Enable enforcement with this:

ALTER TABLE tablename CHECK CONSTRAINT constraintname

-Mike