Re: Drop table from running merge replication

hello

it is not possible to remove a table from running merge replication (this is
a feature in sql2005)
your only way is to reinitialize

thorsten

"Al S" <ajsinet@xxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:f999r4$q07$1@xxxxxxxxxxxxxxxxxxxxxxx
I forgot to mention its SQL Server 2000

"Al S" <ajsinet@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:f997qs$pgi$1@xxxxxxxxxxxxxxxxxxxxxxx
Hi

We have a serious problem with a merge replication that has been running
successfully until some rows were added to one of the tables and now SQL
Server is issuing the following error message

The schema definition of base table 'dbo'.'cmqb_open' at the Subscriber
does not match the table in the Publisher database. Re-establish the
subscription after recreating the base table to match the table at the
Publisher.
(Source: Merge Replication Provider (Agent); Error number: -2147199478)

This table can be recreated so it doesn't matter if its removed from the
publication/subscription. I can't however drop the subscription as it
would screw the unmerged data.

Does anyone know how to get around this problem?

Thanks in advance
Allan





.

Relevant Pages

  • Re: Drop replication question
    ... Looking for a SQL Server replication book? ... I drop the publication and then drop the ... re-create the subscription, and then the snapshot agent runs. ... Is there any negative impact by my dropping and recreating the publication ...
    (microsoft.public.sqlserver.replication)
  • Drop table from running merge replication
    ... successfully until some rows were added to one of the tables and now SQL ... not match the table in the Publisher database. ... after recreating the base table to match the table at the Publisher. ... I can't however drop the subscription as it would ...
    (microsoft.public.sqlserver.replication)
  • Re: Drop table from running merge replication
    ... I forgot to mention its SQL Server 2000 ... does not match the table in the Publisher database. ... subscription after recreating the base table to match the table at the ... I can't however drop the subscription as it ...
    (microsoft.public.sqlserver.replication)
  • Re: Host Name Change and Replication
    ... the msdb.sysjobs did still contain PDB01 as the server originator and this caused the 14274 error about the MSX. ... I then added accountName user to the Security folder again, reenabled replication, and then made sure each agent was using the accountName and tested the replication. ... Unfortunately on DGP09 and TDB10 in their> subscription folder each had a push subscription pointing to PDB01 which no> longer exsists. ...
    (microsoft.public.sqlserver.server)
  • Re: General SQL Server 2005 transactional replication question
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... publication part that requires the primary key constraints rather than the ... create the publication on the publisher and create the subscription, ...
    (microsoft.public.sqlserver.replication)