Either change the order of the import, or drop the constraints prior to import.


-----Original Message-----
From: Annette Boyd
[mailto:mssqldba-ezmlmshield-x94335709.[Email address protected]
Sent: Friday, May 27, 2005 4:39 PM
To: LazyDBA Discussion
Subject: DTS-ing tables in


Dear Gurus:

Anyone have a suggestion for me?

I have "old backup data" tables on SQL - when I bring tables in, do I have to remove the relationships from the current tables? I keep getting "PK_FK" violations because the relationship constraints. But when I remove those - bring in the data - and then put those back in - it seems to be fine.

Is there a way around it? Or is this just one of those "it works so just DO it that way" situations?

Annette




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page