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

[tek2002]

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

 

[asolds]

I'm receiving the same error. Did you have any luck resolving this? Thanks.

 

[mrdenny]

What's the full error you are getting? What OS version and patch level, and what SQL version and patch level?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com