解决"已超过了锁请求超时时段"代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】解决"已超过了锁请求超时时段"

作者:Dezai.CN / 发布于2011/12/31/ 973

当很多在共用你自己的数据时，时不时的会报这种错误“已超过了锁请求超时时段”

<div>set ANSI_NULLS ON</div>
<div>set QUOTED_IDENTIFIER ON</div>
<div>go</div>
<div></div>
<div></div>
<div>ALTER Proc[dbo].[Sp_KillAllProcessInDB]</div>
<div></div>
<div>@DbName VarChar(100)</div>
<div></div>
<div>as</div>
if db_id(@DbName) =Null</div>
<div>begin</div>
<div>Print 'DataBase dose not Exist'</div>
<div>end</div>
<div>else</div>
<div></div>
<div>Begin</div>
<div>Declare @spId Varchar(30)</div>
<div></div>
<div>DECLARE TmpCursor CURSOR FOR</div>
<div>Select 'Kill '+convert(Varchar, spid) as spId</div>
<div>from master..SysProcesses</div>
<div>where db_Name(dbID) =@DbName</div>
<div>and spId <>@@SpId</div>
<div>and dbID <>0</div>
<div>OPEN TmpCursor</div>
<div></div>
<div>FETCH NEXT FROM TmpCursor</div>
<div>INTO @spId</div>
<div></div>
<div>WHILE @@FETCH_STATUS=0</div>
<div></div>
<div>BEGIN</div>
<div></div>
<div>Exec (@spId)</div>
<div></div>
<div>FETCH NEXT FROM TmpCursor</div>
<div>INTO @spId</div>
<div></div>
<div>END</div>
<div></div>
<div>CLOSE TmpCursor</div>
<div>DEALLOCATE TmpCursor</div>
<div></div>
<div>end</div>
<div></div>
<div>
<div>这个时候如果再有这种情况 出现只要你执行一下存储过程就行了如例子</div>
<div>exec Sp_KillAllProcessInDB '要访问的数据库'</div>
</div>
<div></div>

试试其它关键字

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)