The compensate for errors switch was introduced with SQL 2000 SP4. Is it
possible that somehow you are running a different version or service pack
version of SQL Server in the new topology?
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com [quoted text, click to view] "Jacx" <Jacx@discussions.microsoft.com> wrote in message
news:65C1052C-74C4-4991-9F60-4378023CAB43@microsoft.com...
> Hi ,
> Recently due to storage problem i had to move all the databases to local
> disk. The databases were in merge replication and the server was where the
> replication was set.
>
> I generated tje scripts for the replications and disabled the replication
> on
> the server.
> After moving the databases i executed the replication creation scripts but
> then i faced the following errors in the merge agent
>
> The merge process could not initialize the subscription.
> (Source: Merge Replication Provider (Agent); Error number: -2147201011)
> --------------------------------------------------------------------------------------
> Invalid column name 'compensate_for_errors'.
> (Source: ServerName (Data source); Error number: 207)
> -------------------------------------------------------------------------
> The system tables for merge replication could not be created successfully.
> (Source: ServerName (Data source); Error number: 20008)
> -------------------------------------------------------------------------
>
> Can anybody please suggest where did i go wrong and also the solution to
> the
> problem
>
> Thanks in Advance.
> Jacx