Sql Server 锁表解决方法

SELECT 
    request_session_id AS SessionID,
    resource_type AS ResourceType,
    resource_database_id AS DatabaseID,
    resource_associated_entity_id AS ResourceID,
    request_mode AS LockMode,
    request_status AS LockStatus,
    OBJECT_NAME(resource_associated_entity_id) AS LockedTable
FROM 
    sys.dm_tran_locks
WHERE 
    resource_type = 'OBJECT';

杀进程

KILL SessionID