3

After I pulled these datas what I wanted from a SQL Server Database,I can't update on row.I'm receiving the following the error.

enter image description here

enter image description here

3

I suppose that you have used the "Edit top x Rows" feature of Management Studio and wanted to update one row. In case that specific row was already deleted by another user/session then you'll receive the upper error.

I think it's better not use the Management Studio's results grid to update data, but use SQL commands. This way you'll work on last fresh data.

  • @ Marian- first of all,thanks for your interesting.As you said,I'm using T-SQL to update row.But,this process takes my long time.what should I do? – Cell-o Jun 7 '11 at 9:47
  • @Cell-o - that's a different problem. Most likely it's a missing index issue, but you'd better ask a different question about the statement and its duration. – Marian Jun 7 '11 at 18:14
1

The benefit of using SQL commands is that you can also use different isolation levels to preserve the data you are viewing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.