Disabling Referential integrity database-wide on import

Is there a way to disable referential integrity on all destination tables for an import?

Thanks.

No, you have to disable all the related constraints. You can do this by:

1. In Enterprise Manager, see 'Disabling a Foreign Key Constraint with INSERT and UPDATE Statements' topic in SQL2000 Books Online

2. In Query Analyzer, use 'ALTER TABLE' command as:

ALTER TABLEMytableNOCHECK CONSTRAINTFK_MyFKCnt