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 Administration (2000)
 Exporting Primary Keys and Stored Procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-10-29 : 23:56:44
Rob writes "Hi gang. Great site. The Mitchell man from 4Guys sent me here.

I am an ASP/SQL developer. When exporting SQL databases from my local machine to a remote machine I seem to lose the primary keys I have assigned. I have to go back through the database and reassign them. How can I keep them?

Also, I am going to be exporting a large database soon that uses a lot of stored procedures. Will this all transfer over when I export the database or do I have to do something unique for them.

Thanks,

Rob"
   

- Advertisement -