If you have MSDN Look at article: Transactions, Locking, and Concurrency

>Actually in our old versions, we use a similar algorithm. In our current version we plan to allow SQL server as the backend. So we were wondering if this schema would be practical there. Means can we really lock records in SQL Server or do something similar... u have any idea?
>Thanks for replying!