>Can you temporarily drop with contraint with
>
>ALTER TABLE Tablename NOCHECK CONSTRAINT ConstraintName
>
>then reestablish with
>
>ALTER TABLE Tablename CHECK CONSTRAINT ConstraintName

I ended-up dropping all constraints, then re-establishing them:



Print 'Disabling all Constraints'
GO
sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO

-- code to delete records

Print 'Enabling all Constraints'
GO
sp_msforeachtable "ALTER TABLE ? CHECK CONSTRAINT ALL"
GO