I have two servers each with sql 2000 sp3a. When running a distributed transaction between them I get
The operation could not be performed because the OLE DB provider '%ls' was unable to begin a distributed transaction.
It works OK on one of the servers to a 3rd server but not between the two that I need!
The help says to re-write the query if the provider doesn't support distributed transactions ...
Any ideas?