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
Msg 7391, Level 16, State 2, Procedure xyz,
The operation could not be performed because OLE DB provider “SQLNCLI11”
for linked server “abc” was unable to begin a distributed
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.