>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
Thanks.
Chris McCandless
Red Sky Software