找出是誰鎖住了表

SQL

SELECT 
    r.session_id,
    r.status,
    r.start_time,
    r.command,
    t.text AS sql_text,
    l.request_mode,
    l.resource_description
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t
JOIN sys.dm_tran_locks l ON r.session_id = l.request_session_id
WHERE l.resource_type = 'OBJECT'
AND OBJECT_NAME(l.resource_associated_entity_id) IN ('aaa', 'bbb');