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  Import/Export (DTS) and Replication (2000)  Problem using DTS to copy tables and views

Author  Topic  hko Starting Member 8 Posts Posted - 2001-10-31 : 06:14:51 Hi all, A while ago I posted a problem (on another forum of the sqlteam site) stating that my ADO cursor of the openKeyset type changed to the openDynamic type automatically when using the Personal Edition of Sql Server. I have by now found out that it has nothing to do with the PE, the source of the problem lies in my use of DTS. I have database on a NT Server machine running the standard edition of SS2000 and when I use DTS to copy this database (tables and views) to a NT Client machine running the PE of SS2000, EVERYTHING is copied: tables, fields,attributes, datarecords etc, EXCEPT the keys of all the tables ! SS states the all tables have been copied succesfully. Can anyone tell me why the keys aren't copied along with the rest of the tabledefinition ? Is this a bug or a feature ? I haven't seen it on the fixed list of SP1 for SS2000. However I won't be happy if I have to add all keys to all tables again...and that every time I copy a new version of the database from the server to a client running PE. Any help would be much appreciated. Regards, HKO.