sql server如何对表进行查看锁和解锁

 

use master
go

--检索死锁进程
select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name
from sysprocesses
where spid in
( select blocked from sysprocesses where blocked <> 0 ) or (blocked <>0)

 

也可以

select request_session_id,OBJECT_NAME(resource_associated_entity_id) tableName from 
sys.dm_tran_locks
where resource_type='OBJECT'

kill   进程号（sp_lock/sp_who查找死锁的进程和对象）
spid就是锁住表的进程
tableName就是被锁的表名
解锁
kill [spid]