Key column error

[Ken Nicholson]

I am trying to delete a duplicate row in a table and get the following message:

"Key column information is insufficient or incorrect"
"Too many rows were affected by update"

The table does not have any indexes or keys defined.

How can I delete the row?

Thanks,
Ken Nicholson

[carol]

Hey Ken-

I assume you are trying to delete this through Enterprise Manager ? (that's the only place I've seen this error). Microsoft confirms this is a bug ...

you will have to delete the row through query analzyer ...

set rowcount 1
delete from x where y = 11111

(set the rowcount so you only delete the number of rows necessary to retain the one good record)


------------
Ken Nicholson at 4/30/2002 5:01:52 PM


I am trying to delete a duplicate row in a table and get the following message:

"Key column information is insufficient or incorrect"
"Too many rows were affected by update"

The table does not have any indexes or keys defined.

How can I delete the row?

Thanks,
Ken Nicholson