Friday, March 16, 2012

import failed because of FK Constraint

This is what my DBA friend told me to do:

Execute this before download data

ALTER TABLE [dbo].[TableName] NOCHECK CONSTRAINT ALL;

After downloading data remember to execute this.

ALTER TABLE [dbo].[TableName] CHECK CONSTRAINT ALL;

Hope it's useful for you also :D

0 comments:

Post a Comment