--spid 锁表进程
--tableName 被锁表名--查询被锁住的表 SELECT request_session_id as spid,OBJECT_NAME(resource_associated_entity_id) as tableName FROM sys.dm_tran_locks WHERE resource_type='OBJECT'
--解表(解锁) declare @spid int set @spid = 锁表进程 declare @sql varchar(1000) set @sql='kill '+cast(@spid as varchar) exec(@sql)