SQL Man. Stu and can't commit change in open table view

microsoft.public.sqlserver.tools

8 Dec 2005 8:56 PM

Wayne Clarke

When I open a simple lookup table to update a value in a development
environment it fails. What happens is when I change the value a red
exclaimation point pops up and if i move from the changed row to a new one it
I get a Optimistic Concurrency Control Error with the option to commit,
discard, or cancel. If I attempt to commit I get a new error that originates
from Microsfot.VisualStudio.DataTools that says, "The updated row has changed
or been deleted since data was last retrieved." However, I am the only one
that has access to that database so that can't be the case.

I found that if I turn nocount to off on the server that it will work fine
however I need this option turned on.

Anyone else running into this issue or have a fix?