找出是誰鎖住了表
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' );