The operation could not be performed because OLE DB provider ... for linked server ... was unable to begin a distributed transaction (SQL Compare)

This error occurs because of the Transaction Isolation Level.

By default, SQL Compare uses the Serializable Transaction Isolation Level, however this deployment requires a Transaction Isolation Level of Read Committed.

This documentation goes into more detail: 

Was this article helpful?

1 out of 1 found this helpful
Have more questions? Submit a request