>>How exactly did you implement it?
>
>
>

>
>-- Will hold a lock on a record until COMMIT is issued. Exec 1 line at a time in SMSS
>
>
>BEGIN TRANSACTION
>
>SELECT SomeColumn FROM dbo.MyTable WITH (TABLOCKX) WHERE SomeCriteria
>
>(Now run application code against locked record)
>
>COMMIT  -- Releases lock
>
>

Thanks a lot, there was someone on another forum with the similar problem.