Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    4

    Unanswered: updating between linked server

    Whenever I run a query similar to this one trying to update a table in another server:
    update serverxyx.dbxyz.dbo.tablexyz set field2xyz=1 where field2xyz=abc
    I get this error:
    Server: Msg 7346, Level 16, State 2, Line 1
    Could not get the data of the row from the OLE DB provider 'SQEDB'.
    [OLE/DB provider returned message: Row handle referred to a deleted row or a row marked for deletion.]

    Has anyone come up with this before? Is there any workaround? Or what am I doing wrong?

    Thanks in advance for your help.

  2. #2
    Join Date
    Aug 2001
    Posts
    1
    Not really an answer, but just beware. I've had some severe problems doing Deletes and Updates across a linked server.

    Selects and inserts always work great, but after I've gotten everything going it takes MINUTES to delete or update a record. It eventually works but it is slow as a dog. Never really found an answer why, but it has happened to me several times.

    So just a warning for the future.

  3. #3
    Join Date
    Dec 2002
    Posts
    1

    Thumbs up Thanks

    Thanks for the tip !

    Got the same problem myself.

    Kinda long for an update job that updates at most 500 records to run for an hours and a half...

    So I have 2 alternatives :

    Create a job on my linked server that I call from my server
    or
    Call a Stored Procedure on that linked server that does the same update.

Posting Permissions

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