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
 Other Forums
 Other Topics
 Restoring Referencial Integrity

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-01 : 17:52:50
Matt writes "After using DTS to try and push our development database to our production server last night, the developer in charge of that bit ran into a few errors. She tried to correct them as best she could, but upon further investigation, a lot of things went wrong. Most notably, the Primary Keys were not defined in the new production database. I've gone through and set the PK's manually, but because they had not been set by DTS, the dependencies seem to have been broken. Is there any way to restore this?"
   

- Advertisement -