а Snapshot Isolation тоже поддерживается?
а вот, что имелось ввиду под "Optimistic Concurrency Checking":
Optimistic Concurrency Checking for SQL Server 2000 and SQL Server 2005
Optimistic Concurrency Checking for SQL Server versions has been introduced in the Kernel Rollup 1 update. The goal is to improve the performance of single record update operations in Microsoft Business Solutions – Axapta 3.0. The application or Axapta Object Server (AOS) compares the record being updated by rereading the record from the database on update. Prior to this record update, if the record in the database and memory were the same, the changes were merged before the update statement to the database was issued. With Optimistic Concurrency Checking enabled, if the record in the database and the record in memory are the same, the update statement is issued and run. In short, if there is no update conflict with the record, only one database request is made.