>>>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.

You're welcome. Thank Sergey!