RE: I have a problemloading data into the Tables-can anyone help

RE: I have a problemloading data into the Tables-can anyone help

 

  

Sultana,
The problem you are facing is because of some foriegn keys not matching
to the primary key which these foriegn keys are referencing to.Please check
whether the foriegn keys are matching to the primary key they are
refrencing.If not then you have to first update the table with primary key
first before you load the data into the table.

Deepak

-----Original Message-----
From: Sultana, Naheed [mailto:naheed.[Email Address Removed] Thursday, November 21, 2002 12:41 PM
To: LazyDBA.com Discussion
Subject: I have a problemloading data into the Tables-can anyone help


Hi List,

I am trying to insert some data into the tables, and I have Foreign Key
violations, did anyone come across this kind of a problem and how it was
solved, I cannot drop the relationships to put the data in.



TIA


MS Sql Server LazyDBA home page