Open three query windows like so select request_session_id, resource_type, request_mode, request_status from sys.dm_tran_locks where request_session_id in (64, 65)Use this query to determine the locks showing request_session_id resource_type request_mode request_status 64 DATABASE S GRANT 65