October 31, 2001 at 3:13 am
Hi all,
I am having problems with changes to a subscriber not returning changes to the publisher. the subscriber is setup with immediate update with failover to merge. the changes at the publisher are getting to the subscriber but nothing is returning in the opposite direction.
if anyone has any ideas i would be most grateful
Matt thompson
October 31, 2001 at 4:06 am
Sounds like maybe the replication set up failed? You should have triggers on all the subscribed tables, I'd look for those first. If they are present, then you have to figure out why they would be failing. If missing, I'd recommend just redoing replication (use caution not to wipe out data on subscriber, check the box that says subscriber already has data).
Andy
October 31, 2001 at 9:15 am
Thanks for the advice, helped a great deal.
The core of the problem is the sp_script_synctran_commands procedure which is cutting of the end of the input set for the sp_addsynctriggers procedure when it generates the script to produce the triggers.
I am looking into the procedures to get to the root of the problem. when i have an answer i will post it up in case anyone else has the same problem
Matt Thompson
October 31, 2001 at 10:37 am
Matt,
thanks for the followup.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply