Somebody, with a name a lot like mine, managed to enter two records into a table with the same key ID (using Enterprise Manager for a SQL 2000 db).
Now I cannot delete either of the duplicate records. I get this error when I try to delete, or edit, the records:
"Key column information is insufficient or incorrect. Too many rows were affected by update."
I've checked my other tables, and there aren't any that I can find that depend on either of the particular records.
I'd rather not have to try to explain this to my db guy on Monday, so if you can tell me how to fix I'd be greatly appreciative! And I'll swear to never do it again.
Thanks,
-Scott
Now I cannot delete either of the duplicate records. I get this error when I try to delete, or edit, the records:
"Key column information is insufficient or incorrect. Too many rows were affected by update."
I've checked my other tables, and there aren't any that I can find that depend on either of the particular records.
I'd rather not have to try to explain this to my db guy on Monday, so if you can tell me how to fix I'd be greatly appreciative! And I'll swear to never do it again.
Thanks,
-Scott