I've a problem with a table of a sql 2000 server database. Nobody know how, but the table now has duplicate key values for an existing unique index (PK__.....). Then when I try to rebuild this index I get the following message:
Server: Msg 1505, Level 16, State 1 CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '3301'.
How can I fix this problemn and rebuild the PK index?