Take the 2-minute tour ×
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.

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
add comment

2 Answers

up vote 2 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
add comment

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
add comment

Your Answer

 
discard

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.