数据库kill死锁

select * from [dbo].[AccountsInfo](nolock) where Accounts='lqm123123'


select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks where resource_type='OBJECT'


declare @spid int
Set @spid = 403 --锁表进程
declare @sql varchar(1000)
set @sql='kill '+cast(@spid as varchar)
exec(@sql)

posted @ 2015-09-25 15:10  唔愛吃蘋果  阅读(288)  评论(0编辑  收藏  举报