Trigger error

[pvmurphy]

Received this error when executing a store procedure that triggers an Insert trigger. Is there an easy solution to this problem? Thanks in advance.

Jim

Server: Msg 7395, Level 16, State 2, Procedure tgInsPubCap, Line 33
Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF.
[OLE/DB provider returned message: Cannot start more transactions on this session.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013: ISOLEVEL=4096].

 

[TheBugSlayer]

Can u post a piece of the SP and the whole trigger herein?

 

[pvmurphy]

I was actually able to figure this one out on my own, my trigger needed the statement SET XACT_ABORT ON since I was doing a distributed transaction across servers.

Thanks

Jim