Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ERROR: 'SQLOLEDB' was unable to begin a distributed transaction

Status
Not open for further replies.
tek2002

tek2002

Programmer
Aug 21, 2001
67
US
I am using linked server to execute an SP on one server from another. It works fine if on server A i am calling the SP on server B from within a stored proc. I get the above error when if on server A i call the SP on server B from within a trigger.

Dont know why this call to a SP on another server works fine from within a SP but fails when called from within a trigger.

Anyone have any ideas?

Thanks
 
Status
Not open for further replies.

Similar threads

Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
201
drlex
drlex
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
154
botatun
botatun
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
177
drlex
drlex
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
189
kat50
kat50
briangriffin
  • Locked
  • Question
Add Current Date to Insert
Replies
2
Views
80
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top