事务锁表处理

select    
    request_session_id,OBJECT_NAME(resource_associated_entity_id)  
from    
    sys.dm_tran_locks   
where    
    resource_type='OBJECT' 
    
    and OBJECT_NAME(resource_associated_entity_id) = TableName
    
    ORDER by
    
   kill  request_session_id