USE [数据库名]
begin
-- 查询被锁的表和sessionID
select
request_session_id as spid
,OBJECT_NAME(resource_associated_entity_id) as tableName
from
sys.dm_tran_locks
where
resource_type = 'OBJECT'
-- 结束被锁表的进程
declare @spid int, @sqlstr varchar(1000)
set @spid = 上面查询出来的spid
set @sqlstr = 'kill ' + cast(@spid as varchar(50))
exec(@sqlstr)
end