Hi, I tried to synchronize the Database between 2 Servers using Red Gate Compare, I am getting the following error.
 The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "PRODUCT_SERVER" was unable to begin a distributed transaction. OLE DB provider "SQLNCLI10" for linked server "PRODUCT_SERVER" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Anybody got that error before? Do you know how to resolve that issue? Thanks.