Toad World® Forums

Schema Compare - Procedures with code to Linked Servers


#1

When a Schema Compare script is generated which involves a procedure with a linked server in its SQL an error will appear preventing the script from running. If just the ALTER statement is removed from the script and run separately then the script and the procedure will update correctly.

The error message reads as follows:

OLE DB provider “SQLNCLI11” for linked server “abc” returned
message “The partner transaction manager has disabled its support for
remote/network transactions.”.
Msg 7391, Level 16, State 2, Procedure xyz,
Line 17
The operation could not be performed because OLE DB provider “SQLNCLI11”
for linked server “abc” was unable to begin a distributed
transaction.

As always, these “Schema Compare” errors have continued to make our purchase of Toad for SQL Server unusable (now for nearly 12 months). I appreciate your urgency in resolving these critical bugs as soon as possible. Thanks.

-Rudy


#2

Hi,

I create TSS-1208 for this issue and mark it as critical issue. We will try to fix it soon.

We are sorry for your inconvenience.

Best Regards,

Kelly