Monday, March 12, 2012

Key column information is insufficient or incorrect. Too many rows were affected by u

I have edit sql server 2000 table record by vb or direct enterprise mangafer and i have recived one message "Key column information is insufficient or incorrect. Too many rows were affected by update." any guys know this problem pl send the solution

Manish jain

ThanksThe Name Of Allah
hi

In the following table, for example, the error message appears if you attempt to delete one or both of the rows containing "abc" by using SQL Enterprise Manager with the following steps:
1. Right-click on the table.
2. Click on Open table, and then click on Return All Rows.
3. Highlight the rows, and then press the Delete button.

Character_Column1 Character_Column2
abc abc
abc abc
zxy zxy
fgt art

Eng. Maged

No comments:

Post a Comment