>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
Al Williams
Anola MB, CANADA