Hi,
i have used follwing link to tranfer data from different servers.
how to connect different server database tabels[
^]
But after i done that i was getting this error:
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "74.13.0.452" was unable to begin a distributed transaction.
OLE DB provider "SQLNCLI" for linked server "74.13.0.452" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Then i configured of MS DTC in addmistrative tool then also i'm getting this error which is one above.
please reply with an example.