Trigger nserting in OPENDATASOURCE
I have a trigger on a table that inserts data in a external table, referenced through an OPENDATASOURCE call.
The trigger reads :
CREATE TRIGGER whatever On whatevertable
insert OPENDATASOURCE('MSDASQL','DSN=Copy;Uid=x;Pwd=y').g db.dbo.Table1
select blabla from inserted
When running this, the INSERT in the original table whatevertable fails giving me a "Distributed Transaction Error"
I can insert the data using OPENDATASOURCE from the Query Analyser.
Any ideas ?