April 25th, 2000, 08:07 PM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,578
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
SQL Help
<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 />
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
