表锁处理

--查找锁表的进程ID,以及被锁定的表
SELECT request_session_id  AS '锁表id',OBJECT_NAME(resource_associated_entity_id) AS '表名' 
FROM sys.dm_tran_locks WHERE resource_type='OBJECT'
order by  request_session_id 

--查看锁表的进程id所运行的语句
DBCC INPUTBUFFER(锁表id)

--杀死锁定的进程
kill 锁表id