I'm having a problem with a transactional publication failing to add records
from a updatable subscriber on 2000 SP4.
When the Queue Reader Agent runs I get the 'could not find stored proceedure
ins.sp_MSsync_ins_articlename' error.
The one article I can find on the subject states that the problem is the
value of queue_id in the MSsubscription_agents table on the subscriber, which
should be 'mssqlqueuev2'. I've tried that fix and it doesn't work. In fact,
after inserting a record on the publisher the value gets changed back to
'mssqlqueue' on the subscriber.
I set this up taking a backup of the publication database after the
publication is created and applying it to the subscriber. Then I run the
distribution agent once and then change the value in queue_id. I then apply
the scripts generated by sp_scriptpublicationcustomprocs and
sp_script_synctran_commands on the publisher. I assume that these scripts
still need to be used on SP4 for a no sync initialization of the subscriber.
Anyone have any ideas or suggestions? We will be moving all the databases to
2005 in the future, but that probably won't happen until late December or
January and we need to get this working ASAP.
Thanks
--
Jack Harris
>> Stay informed about: Updatable Subscriber fails to update publisher on SQL Serv..