Transaction context in use by another session

Forum for users of SQL Compare schema synchronization utility

Transaction context in use by another session

Postby abean » Mon Apr 22, 2013 5:30 pm

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?

Posts: 4
Joined: Tue Oct 30, 2012 6:48 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests