I have a database that somehow duplicated a PK unique ID. Don't know how it happened but have been working on eliminating the row. If I restore a backup, I will get the message that the ID must be unique, the table loads but the PK is no longer there. If I del dup, I get 182 rows deleted, so then I go back to table definition and try to create the PK, but cannot. If however, I take a copy of the database, del duplicates, everything is fine. So I have several questions: 1. Why does the problem of del dups from a restored copy not work, yet from a copy it does. 2. How is the best way to look at the duplicated rows 3. How can a duplicated ID get in a PK.
Thanks, Tom Hart
