SQL Server之批量清理数据库的死锁
DECLARE killspid
CURSOR FOR (SELECT CONVERT(VARCHAR(100), request_session_id) FROM sys.dm_tran_locks WHERE resource_type='OBJECT' )
OPEN killspid
DECLARE @sql varchar(1000)
DECLARE @spid varchar(36)
FETCH NEXT FROM killspid INTO @spid
WHILE @@FETCH_STATUS=0
BEGIN
set @sql='kill '+cast(@spid as varchar)
exec(@sql)
FETCH NEXT FROM killspid INTO @spid
END
CLOSE killspid
DEALLOCATE killspid
GO