锁的问题

锁的问题

>

现在老是出现这样的错误提示!

-2147467259 Your transaction(process ID #30) was deadlocked with another process and has been chosen as the deadlock victim.Return your transaction.

use master

go

create proc killspid (@dbname varchar(20))

as

begin

declare @sql nvarchar(500),@temp varchar(1000)

declare @spid int

set @sql=@#declare getspid cursor for

select spid from sysprocesses where dbid=db_id(@#@#@#+@dbname+@#@#@#)@#

exec (@sql)

open getspid

fetch next from getspid into @spid

while @@fetch_status<>-1

begin

set @temp=@#kill @#+rtrim(@spid)

exec(@temp)

fetch next from getspid into @spid

end

close getspid

deallocate getspid

end

--用法

use master

exec killspid @#数据库名@#