sqlserver表查看被锁表和解锁方法

1、---查看锁表

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

---spid 锁表进程 

---tableName 被锁表名 

---解锁语句

 declare @spid int 

 Set @spid = 136 

 --锁表进程

 declare @sql varchar(1000)set 

 @sql='kill '+cast(@spid as varchar)exec(@sql)