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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS

Author  Topic 

Rita Bhatnagar
Posting Yak Master

172 Posts

Posted - 2001-03-06 : 17:18:41
We used DTS to copy data from access database to sql server 2000.What happened is it didn't set primary key for tables. We have more than 500 tables. any suggestions?
We are migrating from access to sql server but still access is the main database.
Thanks for any kind of help.

   

- Advertisement -