Error: Transaction context in use by another session

vincentjvincentj Posts: 47
edited October 17, 2011 2:11PM in SQL Compare Previous Versions

I can't get the synchronization wizard to work at all. First I was getting the error: "MSDTC on server 'blah' is unavailable". So I went into services and enabled the Distributed Transaction Coordinator service, and now I always get the error "Transaction context in use by another session."

The only way that I've found to get around this is to modify the script by hand and change the isolation level to READ COMMITTED. Eventually I plan on using this tool to automate our database deployments so I need to get it working without manual intervention. Is there a configuration option somewhere that I can change to fix this problem? Thanks.

This error was present in the previous version also (8.5).


Sign In or Register to comment.