Transaction context in use by another session

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Transaction context in use by another session

Postby abean » Mon Apr 22, 2013 6: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 7:48 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests