如何检测数据库中对象被锁定及解除锁定的方法

exec sp_lock --find the lock process
kill 83 --kill lock process

--find which object(general is table) was locked
select * from sys.all_objects       
where object_id like '%1115151%'
order by object_id

select * from sys.tables order by object_id 

select * from sys.columns 
where object_id like '%1115151%'
order by object_id

 

执行exec sp_lock语句后的结果