From: Sean O'Halpin <sean.ohalpin@...>
Date: 2005-11-09T09:42:30+09:00
Subject: Re: Checking for race conditions with Ruby threads

On 11/9/05, Sean O'Halpin <sean.ohalpin@gmail.com> wrote:
> On 11/9/05, Wilson Bilkovich <wilsonb@gmail.com> wrote:
> > Unfortunately, this is a SQL Server application being used as a 'work
> > queue', and SQL Server 2000 does not allow exclusive locks on rows.

Look up ROWLOCK in SQL Books Online. You might also want the READPAST
locking hint to skip locked rows held by other processes.

Regards,

Sean