Cannot delete or change duplicate rows in table

[elallred]

I have a sql server table (PAF6) with about 10 duplicate rows out of 940. (This table has 540 columns -- although I do not think this relevant). I can delete or modify the data in every row except these 10. I get the error message "key column information is insufficient or incorrect. Too many rows affected by update".

There no fields designated a key fields in the table and there are no dependencies that I can find.

I have made a copy of the table under another name and still have the same problem.

Can anyone help?

Thanks

 

[Corwyn]

Exactly, you have no key information. Therefore say you have row A with the exact same data as Row B. Well when you highlight ROw A (or slect it with a query) SQL cannot make any distinction to know you want to delete Row A and NOT Row B.

Workaround - Add an autoincrement identity field to the table, this will provide Key information, delete your Dups, and then remove the identity field (or keep it if you expect this to happen every now and then).

HTH