patternsqlMinor
Distributed transaction and Read Committed Snapshot
Viewed 0 times
committedreadsnapshotdistributedtransactionand
Problem
Distributed transactions are not supported for snapshot isolation level in SQL Server 2008 R2. But what about read committed snapshot?
Solution
Yes RCSI is supported for use with distributed transactions as documented in Books Online:
Choosing Row Versioning-based Isolation Levels
Choosing Row Versioning-based Isolation Levels
Context
StackExchange Database Administrators Q#48114, answer score: 7
Revisions (0)
No revisions yet.