Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eddie
Starting Member
45 Posts |
 Posted - 2002-04-16 : 15:50:47
|
| I have a table with no keys or indexes and it is not referenced by any other tables...there are four rows in the table that if I try to update a column by entering data through enterprise manager, I get the error 'Key column information is insufficient or incorrect. Too many rows were affected by update.' but I can update these rows fine in query analyzer...what is wrong?Thanks,Eddie |
|
|
WildMan
Starting Member
22 Posts |
Posted - 2002-04-16 : 17:19:21
|
| Does each row have a unique ID? Usually you get this error if each row doesn't have an ID number that is unique to that row of data. Thus when you do the update it is probably trying to update more than one column of data which is giving you the error statement.Joey |
 |
|
|
|
|
|
error in enterprise manager...