SQLserver 数据库锁表

-- 查询所有的锁
exec sp_lock;
-- 查询指定进程的锁
exec sp_lock [spid];
-- 根据系统视图查询指定进程的锁
select * from sys.dm_tran_locks where request_session_id=[spid];
-- 查看被锁表
select   request_session_id   spid,OBJECT_NAME(resource_associated_entity_id) tableName  from  sys.dm_tran_locks where resource_type='OBJECT';
-- 结束进程
kill [spid]