Question is in the title. I'd just love to understand why this isn't supported?
Just to clarify this is MS Sql Server 2005 / 2008.
views:
148answers:
1
A:
Because it's potentially inconsistent and it's weaker out of the box than lock-based isolation (ANSI SQL).
Or, the downsides (such as this banking example) require more work and thinking to keep things correct so it's simply safer not to support it.
Finally (I've not checked), is it in the ANSI standard? It could be a very bespoke solution and you'd be unable to use distributed transactions against other platforms
gbn
2009-08-26 04:54:36
No the technical implementation of the locking seems fine, as to how it works. I just don't understand why they haven't allowed snapshot to work when MSDTC performs the commit. It works with all other levels, just not snapshot :'(
Spence
2009-08-26 09:20:07