Evaluating SQL Source Control - Linked server on Get Latest
Hello!
I am trying to run a get latest command in the Source Control module - there's 1 stored procedure it's trying to update my local DB with that has a linked server. The linked server does not allow distributed transactions and I saw that the tool is setting the transaction isolation level to serializable. This is preventing the change from going through - is there a way to change the isolation level that is being used when running "Get Latest"?
Severity Code Description Project File Line
Error 'TestDB.dbo.spWithLinkedServer': The operation could not be performed because OLE DB provider "MSOLEDBSQL" for linked server "jitsql" was unable to begin a distributed transaction. OLE DB provider "MSOLEDBSQL" for linked server "jitsql" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Located at: C:\Users\apgentry\AppData\Roaming\Devart\dbForge Common Settings\Repositories\w3ovp3w5\Programmability\Procedures\dbo.spWithLinkedServer.sql Source Control: TestDB(reports) 1