HI ,

I accidently removed the primary keys in my table , Have ben trying to "reset " the primary keys since then but to no avail.....is there a way that i can "recreate" those primary keys so that it can be the same as before ....I kep getting the error

Unable to create index 'PK_Table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '1'.

Pls Help