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
Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.