数据一直在变化(SQL Server Management Studio) [英] Data has always changed(SQL Server Management Studio)

问题描述

我正在使用SQL Server Management Studio并不断出现相同的错误，而摆脱它的唯一方法(通常)是重置SQL Server(这很烦人，有时在我的远程计算机上是不可能的)

当我向表中添加一行，然后转到编辑前200行"时，所有这些都显示并运行良好，然后转到要更改的字段.然后，我更改类似 0->的内容.1 ，然后我会看到一个友好的弹出窗口，上面写着自上次检索结果窗格以来数据已发生更改……乐观并发控制错误".如果从这里我说是，无论如何都将更改提交到数据库"，我会得到没有更新行...自从上次检索数据以来，更新的行已更改或删除.

这是一件非常令人讨厌的小事情，因为我不喜欢先查找RID然后编写一条更新语句(并且可能不必担心手动转义'

是否有某种方法可以关闭此并发检查?我知道该行没有更新或什么，我尝试完全关闭Sql Server Management Studio并重新打开无济于事，还尝试刷新结果窗格或刷新列视图.没有任何东西可以消除此错误，但是如果我执行"update ... set ... = ..."，那么它将起作用，因此我并没有真正的并发错误.

解决方案

0 -> 1 and then I get a nice friendly popup saying "Data has changed since the Results Pane was last retrieved... Optimistic Concurrency Control Error" If from here I say "Yes to commit changes to database anyway" I get "No row updated... The updated row has changed or been deleted since data was last retrieved"

It's a very annoying little thing, cause I don't like having to look up RIDs and then make an update statement(and possibly having to worry about escaping 's by hand)

Is there some way to turn this concurrency checking off or something? I know the row wasn't updated or anything, and I tried completely closing Sql Server Management Studio and reopening to no avail, and also tried refreshing the result pane, or refreshing the column view. Nothing gets rid of this error, but if I do a "update ... set ...=..." then it works, so I'm not really having any concurrency error..

解决方案

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/7bf48a75-58a0-41d7-b514-b804a49ae8ff/

it seems to be a bug in SSMS I don't think I have over 4000 characters, but I can confirm this only happens on rows that have more data than others.. there seems to be some abritary limit that I can't quite put my finger on..

So, plainly SSMS is complete crap. I'll be looking for a new SQL manager..

这篇关于数据一直在变化(SQL Server Management Studio)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！