Sql Server如何查看被锁的表及解锁的方法

查看被锁表： select spId from master..SysProcesses where db_Name(dbID) = '数据库名称' and spId <> @@SpId and dbID <> 0 解除锁： exec ('Kill '+cast(@spid as varchar)) 查看被锁表： select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' spi