I'm working on a trigger that will update a table on a different SQL Server when the address table is updated and I can't seem to get it to work properly. I keep getting the following error
Any idea what could cause this error?Code:Server: Msg 7392, Level 16, State 2, Procedure Store_System_Update, Line 44
Could not start a transaction for OLE DB provider 'SQLOLEDB'.
[OLE/DB provider returned message: Cannot start more transactions on this session.]
