- 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]