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 |
|
taylo
Yak Posting Veteran
82 Posts |
 Posted - 2000-12-27 : 13:17:41
|
| I have seen SQL Server 7.0 duplicate tables when the serverthrows a data transfer error but it actually imports the table design.It happens if you fail to drop and recreate.However I just noticed a colleague took an existing database and imported it under a new db name from a different SQL server account.The tables are now duplicated. One table has his account and the other table has my account. Could this have happened because he tried to import under a different account? Or do you think he had trouble importing? I use DTS and I assume he did as well.Will this cause duplicate tables as well. I.E. different tables with the same name for different accounts? It took the tables and duplicated them. 1 table for my user accoutn and one for him.If anyone has an answer let me know and thanks,Rob |
|
|
|
|
|
Duplicate tables