Answer: SQL Server - How to lock a table until a stored procedure finishes

with (tablock, holdlock)

answer re: SQL Server - How to lock a table until a stored procedure finishes

Feb 28 '17

19

BEGIN TRANSACTION

select top 1 *
from table1
with (tablock, holdlock)

-- You do lots of things here

COMMIT

This will hold the 'table lock' until the end of your current "transaction".

</p>

Open Full Answer

Lock a table while doing some stuff