What are the challenges you face when working across database platforms? Take the survey

Transaction context in use by another session

abeanabean Posts: 6
edited April 22, 2013 1:30PM in SQL Compare Previous Versions
Hey all,

The error is thrown when attempting to deploy objects that have a four part (linked server) call in the procedure definition.

This was an issue with older versions of Compare; however it was fixed as they gave us the ability to change the isolation level. Changing it to READ COMMITTED did resolve the issue; however with the latest upgrade to 10.3.8, the issue has returned.

I can not roll back to a previous version either because I upgraded to this one to resolve the columnstore indexing comparison issues.

Any thoughts?

Sign In or Register to comment.