SQL Service锁表 解锁

方法/步骤 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)