I'm getting the following error when trying to fire a
trigger to a different server:
The operation could not be performed because the OLE DB
provider 'SQLOLEDB' was unable to begin a distributed
[OLE/DB provider returned message: New transaction cannot
enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
Original trigger definition:
CREATE trigger trg_InsertNiobeRob on dbo.tblRob
set xact_abort on
declare Id int
select Id = ID
select * from inserted
where ID = ID
MSDTC is started ok. ...