optimistic offline locking using a timestamp column

[Gernot]

Hi

I have the following problem: We have a large legacy database on MS
SQL Server 2005. Each table uses a timestamp column to implement
optimistic offline locking. We want to build a rails application that
uses this database as is. Is there a way that rails can use the
timestamp columns for its own locking magic?

Setting the lock column with "set_locking_column" doesn't do the
trick. The timestamp columns have to stay since there is another app
that uses this database and we cannot modify it.

Thank you for any suggestions
Gernot