22,210
社区成员
发帖
与我相关
我的任务
分享
DECLARE
@s varchar(8000);
SET @s = '';
SELECT
@s = @s + ';KILL' + RTRIM(blocked)
FROM(
SELECT DISTINCT
blocked
FROM master.dbo.sysprocesses WITH(NOLOCK)
WHERE blocked > 50
)A;
EXEC(@s);
checkdb