"Al S" <ajsinet@nospam.netspace.net.au> wrote in message
news:f997qs$pgi$1@otis.netspace.net.au...
> 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
>

>I forgot to mention its SQL Server 2000
>
> "Al S" <ajsinet@nospam.netspace.net.au> wrote in message
> news:f997qs$pgi$1@otis.netspace.net.au...
>> 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
>>
>
>