The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

I guess that's one of the classical (legacy?) SQL Remote questions.

Usually, the operation from the sender is not sent back to that remote, in order to prevent send/resend cycles. That's a reasonable think, as it would usually be no good if the just INSERTed row would bounce back as an additional INSERT:)

However, there seem to be a few exceptions:

  • An UPDATE conflict is detected at the consolidated. Then the resulting row is sent to all subscribers, including the sending remote. AFAIK, that requires the usage of the special RESOLVE UPDATE triggers.

  • One uses the UPDATE PUBLICATION statement to explicitly move rows between subscribers. (However, I'm not sure if this really can move a row back to the sender.)

  • One uses a SQL Remote hook procedure to "delay the response" of an action from the SQL Remote "applying messages" phase to a later phase, e.g. with the sp_hook_dbremote_receive_end() hook. In such a phase, there is no more "current remote user", and each action gets send to all subscribers.

While re-thinking about an ASA 8.0.3.5574 SQL Remote setup, I have found unsure as when exactly such re-sending takes place.

So I would greatly appreciate more insight here - to fill/correct this list of exceptions:)


Source: Partly the NG entry "Re: Can Update Publication force an update?" by Rob Waywell, cf.news://forums.sybase.com:119/r9Unc0qM$GA.268@forums.sybase.com.

asked 22 Feb '10, 16:54

Volker%20Barth's gravatar image

Volker Barth
29.5k291441646
accept rate: 32%

Just to add: I would also like to know if there is a need for something like a small "SQL Remote knowledge base" here. SQLA might be more helpful for such questions than those old NG topics...

(22 Feb '10, 16:58) Volker Barth

@Volker: Feel free to post ANYTHING related to SQL Remote... copy and paste from old newsgroup topics is OK with me.

(22 Feb '10, 20:10) Breck Carter

@Volker: Small world, I just spent the morning at a client site trying to resolve a funky SQL Remote 8.0.3 issue involving missing log files. Alas, the solution was the most-hated "re-extract".

(22 Feb '10, 20:12) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×73
×37

question asked: 22 Feb '10, 16:54

question was seen: 1,149 times

last updated: 22 Feb '10, 16:54