I'm trying to create triggers for automated replication where I have one master database with all the information, then several smaller databases that only have information for each squadron using the database. I created a linked server to each child on the master, and a linked server to the master on each child. Now I can use four part names to access data on the master server from a child server and visa-versa. However, when I try to insert data into a table it tells me:
"The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."
I understand the concept of this message, but have no idea why it would be having problems. Help would be much appreciated.
"The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."
I understand the concept of this message, but have no idea why it would be having problems. Help would be much appreciated.