Hi:

I trying to import data using DTS. The foreign key contraints are firing
because data is being inserted into child tables before parent. When
importing data, is there a way to turn the foreign key contraints off?
This is big database, so it's not practical turn each off individually.

Thanks,
Charlie

What about

ALTER TABLE tablename
NOCHECK CONSTRAINT ALL


You can then re-enable a disabled constraint with


ALTER TABLE tablename
CHECK CONSTRAINT constraintname

Allan

"Charlie@CBFC" <charle1 (AT) comcast (DOT) net> wrote