Hibernate 1.2.0 GA
Using MS SQL 2005

Let's say, we have simple db (it may be splitted later) with few tables (huge ones -- records are permanent, only markable as deleted), some of which have column version (to synch parts of db with other dbs through interface that's using nhibernate). The problem is that we want now implement revision number to reflect all the changes on those tables (sequential, unique) that will be incremented and applyed to any new/changed records.
Adding/changing of records is possible through another interfaces which can be running on remote hosts in parallel.

Is it possible to implement this scheme by using only (mostly?) nhibernate (w/o external stuff such as triggers on server side)?