5

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

marc_s
  • 9,052
  • 6
  • 46
  • 52
Rolf
  • 153
  • 2

1 Answers1

7

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

Choosing Row Versioning-based Isolation Levels

BOL extract

Paul White
  • 94,921
  • 30
  • 437
  • 687