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