Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 3 down vote accepted

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.

share|improve this answer
@ 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

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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