"Martin Miethe" <mmiethe@protours.cl> wrote in message
news:431f6898$0$24148$9b4e6d93@newsread4.arcor-online.net...
> Hello NG,
>
> I need a Replication(Snapshot) from a MS-SQL Server 8 to another MS-SQL
> Server 8.
> With the help of the wizard I set everything (origen, destination,
> publication etc.) up.
> The replication (seems) to run correctly but my problem is, that the
> data gets appended on the Subscriber. But I want the data to be
overwritten.
> Under properties of the publication and then articles, I can determine
> the behavior of the snapshot: In case the table exists on the Subscriber
> the 1) table can be deleted and re-created or 2) all data of the table
> can be deleted. I tried both options with my tables but the data was
> still appended.
> Does anyone have an idea how I can change this behavior? Thanks a lot in
> advance.
> Cheers

Hilary Cotter wrote:
> The only way this could happen is
>
> 1) you are using the additive conflict resolver with merge replication
> 2) your snapshot is configure to keep the existing table intact. To check
> this right click on your publication, select the articles tab, click on the
> problem article, and in the snapshot tab, select the delete option