Hi All,

After lot of struggle, I finally found the solution. Adding 'FOR UPDATE NOWAIT' helped really. Ofcourse it did not happen without any reference online. I found a blog written...

All pardon me, for the incorrect SQL Server version, it should be SQL Server 2000

Thanks,

Prasanna.