LockMode.sql

SELECT
    tl.request_session_id,
    tl.resource_type,
    tl.resource_description,
    tl.request_mode,
    tl.request_status,
    es.login_name,
    es.program_name,
    st.text AS sql_text
FROM sys.dm_tran_locks AS tl
JOIN sys.dm_exec_sessions    AS es ON es.session_id = tl.request_session_id
JOIN sys.dm_exec_connections AS ec ON ec.session_id = es.session_id
CROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle) AS st
WHERE tl.resource_database_id = DB_ID()
  AND tl.resource_associated_entity_id = OBJECT_ID('dbo.PrognoseAntwoord');