Kill进程时报‘Cannot use KILL to kill your own process.’
0
现在碰到一个问题,数据库锁表,所以从网上搜了搜材料自己解锁。
但是现在报Cannot use KILL to kill your own process.这个问题
请帮忙看一下是不是写的脚本有啥问题。
脚本:
with ta
as (select distinct request_session_id spid
from sys.dm_tran_locks where resource_type='OBJECT'),
tb
as
(select ROW_NUMBER() over (order by spid) ID,spid from ta)
select * into #HarveyLock from tb;
declare @spid int
declare @ID int
declare @num int
set @num=(select max(ID) from #HarveyLock)
set @ID=1
while @ID<=@num
begin
declare @sql varchar(1000)
set @spid=(select spid from #HarveyLock where ID=+cast(@ID as nvarchar))
set @sql='kill '+cast(@spid as varchar)
exec(@sql)
set @ID=@ID+1
end
drop table #HarveyLock
但是现在报Cannot use KILL to kill your own process.这个问题
请帮忙看一下是不是写的脚本有啥问题。
脚本:
with ta
as (select distinct request_session_id spid
from sys.dm_tran_locks where resource_type='OBJECT'),
tb
as
(select ROW_NUMBER() over (order by spid) ID,spid from ta)
select * into #HarveyLock from tb;
declare @spid int
declare @ID int
declare @num int
set @num=(select max(ID) from #HarveyLock)
set @ID=1
while @ID<=@num
begin
declare @sql varchar(1000)
set @spid=(select spid from #HarveyLock where ID=+cast(@ID as nvarchar))
set @sql='kill '+cast(@spid as varchar)
exec(@sql)
set @ID=@ID+1
end
drop table #HarveyLock
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
1 个回复
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2015-05-15 回答
赞同来自: