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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-06 : 10:52:03
|
JB writes "(SQL 7.0 & NT 4)
I was using DTS to transfer a table (structure and data) from one server to another. The structure was built successfully on the destination server but the data was not transferred successfully. DTS's error indicated a unique constraint violation. Because of this I dropped all indexes on the table and transferred the data over to the destination server. I then went about trying to find the invalid data causing the violation. I tried to recreate the unique index on the destination table (just to make sure) and it was created successfully.
Also, I ran some queries on the data and found no duplicate data on indexed fields.
Has anyone seen this before or could someone explain how this could be happening?
Thanx
JB" |
|
|
|
|
|
DTS import of table structure and data