sqlserver锁表查看和处理教程

查看被锁表

select request_session_id 锁表进程,object_name(resource_associated_entity_id) 被锁表名

from sys.dm_tran_locks where resource_type=’object’;

解锁

declare @spid int

set @spid = 55 –锁表进程

declare @sql varchar(1000)

set @sql=’kill ‘+cast(@spid as varchar)

exec(@sql)