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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-01-12 : 12:13:56
|
| Error: "Key Column Info is insufficient or incorrect. Too many rows were affected by Update" I get that error when I try to delete rows directly (manually) using SQL server entreprise manager. When I use a query through SQL query or analyser, I don t get that error. I only get it when manually selecting rows and clicking delete.I appreciate your help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-12 : 13:19:25
|
| Enterprise Manager shouldn't be used to modify data. EM has lots of limitations. Do you have a primary key on the table?Tara Kizeraka tduggan |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-01-12 : 13:41:34
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60232 |
|
|
|
|
|
|
Key Column Info is insufficient or incorrect. Too