SqlServer数据库表被锁的解锁方法

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