SQL Server transaction isolation level Snapshot cannot be promoted by DTC. In case you open a transaction scope in .NET code, using isolation level snapshot, then open a connection, leave that connection open, and try to open another connection, you will retrieve an exception saying that a snapshot transaction cannot …

Continue reading “SQL Server Isolation Level Snapshot & DTC Promotion”