Distributed transaction and Read Committed Snapshot

Posted on

Question :

Distributed transactions are not supported for snapshot isolation level in SQL Server 2008 R2. But what about read committed snapshot?

Answer :

Yes RCSI is supported for use with distributed transactions as documented in Books Online:

Choosing Row Versioning-based Isolation Levels

BOL extract

Leave a Reply

Your email address will not be published. Required fields are marked *