SqlServer 查看被锁的表和解除被锁的表
时间：2021-07-01 10:21:17
帮助过：22人阅读
request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName
from sys.dm_tran_locks
where resource_type=
‘OBJECT‘
declare @spid int
Set @spid =
74 --
锁表进程
declare @sql varchar(1000)
set @sql=
‘kill ‘+cast(@spid
as varchar)
exec(@sql)
SqlServer 查看被锁的表和解除被锁的表
标签：char sqlserver oci int soc logs tran sso select
