SQLServer check lock status

check_lock.sql

SELECT
     resource_type AS type
    ,resource_associated_entity_id as entity_id
    ,( CASE WHEN resource_type = 'OBJECT' THEN
          OBJECT_NAME( resource_associated_entity_id )
      ELSE
          ( SELECT
              OBJECT_NAME( OBJECT_ID )
           FROM
             sys.partitions
           WHERE
               hobt_id=resource_associated_entity_id )
      END)
        AS object_name
    ,request_mode AS request_mode
    ,request_type AS request_type
    ,request_status AS request_status
    ,request_session_id AS session_id
FROM
    sys.dm_tran_locks
WHERE
    resource_type <> 'DATABASE'
ORDER BY
    request_session_id