<i><b>Originally posted by : T. Teal (tteal@starpower.net)</b></i><br />Hi! I have an SQL database (SQL 7) and not sure how it happened, but I have duplicate ID's.<br /><br />What I'm trying to do is delete them, however, every time I go and open up SQL Enterprise, view all rows and click on the row I want to delete... I get this error:<br /><br /> Key columns insufficient or incorrect. Two many rows were affected by update.<br /><br />What I'm wondering is how can I get rid of these duplicate ID's safely?<br /><br />Thank you.<br />