mssql死锁

SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName 
FROM sys.dm_tran_locks 
WHERE resource_type='OBJECT ' 

 

Kill id

posted @ 2015-02-26 17:01  guojian2080  阅读(133)  评论(0编辑  收藏  举报