Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-07-19 : 03:12:57
|
| Hi allIn my database D1, a table T1 was dropped by mistake,,we have a backup of the database and restored it and trying to import the table to the D1...when i am trying to import..i am getting foreign key violation problemthe table i am trying to import is having some constraints on it..pls help me on this issue..Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-19 : 03:38:01
|
It looks like some of the foreign key data might have been removed.You can import the data of T1 into a temporary staging table (without any foreign key) and validate the data before inserting back to table T1.
KH |
 |
|
|
|
|
|
erro while Importing a table