Merge Replication only modifies differentials after the first snapshot.
The snapshot is only loaded when adding or re-initialize a subscriber.
After that, only data differences on existing tables will propagate.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: Walter Coppola
[mailto:mssqldba-ezmlmshield-x63441.[Email address protected]
Sent: Thursday, August 26, 2004 8:45 AM
To: LazyDBA Discussion
Subject: system stored procedures not replicating to
subscriders...........



Hello,

Basically l have a merge replication situation occurring which
is working okay, but when l add two new tables to the publication,
re-create snapshots, when the subscribers replicate the tables come
down, but not associated stored procedures. When the tables are
populated with the data the following error occurs "could not find
stored procedure sp_ins_f2323234....."

If l re-initialize the subscribers it seems to work, but is there a way
around not re-initializing the subscribers ? Will re-initializing cause
data loss ? Is there a problem with the database ?

Regards,

Walter




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page