Hi,

What T-SQL statement do you temporarily turn off a foreign key or other constraint, in order to move a bunch of data with a series of bulk INSERT statements?

Thanks!

-- Foreign Key Example
ALTER TABLE Sales.ContactCreditCard
    NOCHECK CONSTRAINT FK_ContactCreditCard_Contact_ContactID
-- Check Constraint Example
ALTER TABLE Person.Contact
    NOCHECK CONSTRAINT CK_Contact_EmailPromotion

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Perfect. Thank you David.

Aaron