<div>
Have you checked the HOLDLOCK and READPAST table hints?<br />
<br />
The HOLDLOCK will hold your lock on the record until the currect transaction end.<br />
You have to define you own transaction with BEGIN TRAN and, depending in the user a COMMIT TRAN or ROLLBACK TRAN<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms187373.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms187373.aspx</a>
</div>


Have you checked the HOLDLOCK and READPAST table hints?

The HOLDLOCK will hold your lock on the record until the currect transaction end.
You have to define you own transaction with BEGIN TRAN and, depending in the user a COMMIT TRAN or ROLLBACK TRAN

http://msdn.microsoft.com/en-us/library/ms187373.aspx [http://msdn.microsoft.com/en-us/library/ms187373.aspx]

<div>
Create a column in the table that indicates the row is locked. &nbsp;Set it when you are editing it and clear it when you are done. &nbsp;In addition, have a job run every 5 minutes to clear the flag on rows that show locked more than 5 minutes.
</div>


Create a column in the table that indicates the row is locked.  Set it when you are editing it and clear it when you are done.  In addition, have a job run every 5 minutes to clear the flag on rows that show locked more than 5 minutes.

<div>
angelIII:<br />
<br />
Very good. I can do that. I don't think I need any more info. This will work fine.<br />
Thanks for the ideas.
</div>


angelIII:

Very good. I can do that. I don't think I need any more info. This will work fine.
Thanks for the ideas.

<div>
<div class="content wysiwyg-content">
I am using MS SQL 2005.<br />
I want to <br />
- obtain the next unlocked record in a table and lock it all at once so no other user can fetch it.<br />
- work on the record for maybe 5 minutes. ( while doing this no one else can use the record)<br />
- update the record and release the lock on it.<br />
<br />
Also if the user &nbsp;decides not to update, a way to release the lock on <br />
this record.<br />
<br />
Your help is greatly appreciated.<br />
Thank you<br />

</div>
</div>


I am using MS SQL 2005.
I want to 
- obtain the next unlocked record in a table and lock it all at once so no other user can fetch it.
- work on the record for maybe 5 minutes. ( while doing this no one else can use the record)
- update the record and release the lock on it.

Also if the user  decides not to update, a way to release the lock on 
this record.

Your help is greatly appreciated.
Thank you


MS SQL Row Locking and Release

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.