Merhaba,
aşağıdaki/alttaki sorgu ile Lock olmuş " request_session_id " yi tespit edin.
Sonra " kill 123 ; " oturumu silin/kill edin.. "kill request_session_id "

SELECT OBJECT_NAME(P.object_id) AS TableName, Resource_type, request_status, request_session_id
FROM sys.dm_tran_locks dtl
JOIN sys.partitions P ON dtl.resource_associated_entity_id = p.hobt_id
WHERE OBJECT_NAME(P.object_id) = 'Give' ;

Umarım işinize yarar.