Sql-server – SQL Server 2005 Row update problem

sql-server-2005

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

Best Answer

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.

Related Question