mssql查看被锁的表

• 查看被锁的表
  spid   锁表进程 
  table_name  被锁表名
  

            SELECT    request_session_id spid ,
                      OBJECT_NAME(resource_associated_entity_id) table_name
            FROM      sys.dm_tran_locks
            WHERE     resource_type = 'OBJECT'

• 解锁
  

  kill 'spid'