Results 1 to 2 of 2

Thread: Updating SQL Server via linked server

  1. #1
    Joe_B
    Guest

    Updating SQL Server via linked server

    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

    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.]
    Any idea what could cause this error?

  2. #2
    Joe_B
    Guest
    Does anybody have an answer for this?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width