sql锁表查询和解锁

----

----sql锁表查询和解锁

----

select   request_session_id   spid,OBJECT_NAME(resource_associated_entity_id) tableName   ,request_mode

from   sys.dm_tran_locks 
where resource_type='OBJECT' 
and OBJECT_NAME(resource_associated_entity_id) is not null 
order by tableName 


declare @spid  int 
Set @spid  = 196 --锁表进程
declare @sql varchar(1000)
set @sql='kill '+cast(@spid  as varchar)
exec(@sql)