Help get this topic noticed by sharing it on Twitter, Facebook, or email.

OLE DB provider for linked server was unable to begin a distributed transaction

Getting this error "OLE DB provider for linked server was unable to begin a distributed transaction" SQL 2008. I have two SQL server 2008 machines. DBAmp is installed on one machine. I have a stored proc on machine 1 that looks up data in a table and calls the stored proc on machine 2 that does the insert with DBAmp. This works when I execute the stored proc on machine 1 from SQL Manager. When I try to run it from a table insert trigger I get the error.
1 person has
this question
+1
Reply