阅读背景:

如何找到什么是锁定我的表

来源:互联网 

I have a SQL table that all of a sudden cannot return data unless I include "with (nolock)" on the end, which indicates some kind of lock left on my table. I've experimented a bit with dm_tran_locks to identify that there are in fact a number of locks on the table, but how do I identify I have a SQL table that all of a sudden cannot




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: