"CrudeOil" <bcomeau@canada.com> wrote in message
news:1148681905.836536.170340@i40g2000cwc.googlegroups.com...
> Hi,
>
> I've added a couple new fields to a table. There are 10 subscriptions
> on this publication. Only 1 has problems synchronizing since. First
> error is:
>
> The merge process could not clean up the subscription to
> 'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number:
> MSSQL_REPL-2147200965)
> Get help: http://help/MSSQL_REPL-2147200965
> New request is not allowed to start because it should come with valid
> transaction descriptor. (Source: MSSQLServer, Error number: 3989)
> Get help: http://help/3989
>
> If I reinitialize AND check to upload changes before reinitialize then
> I get
>
> The schema script ' if not exists (select * from syscolumns where name
> = N'NewCol1' and id = object_id(N'[dbo].[Table1]')) if not exists
> (select * from syscolumns where name = N'NewCol2' and id =
> object_id(N'[dbo].[Table1]')) if object_id(N'[dbo].[Table1]') is not
> null exec('ALTER TABLE [dbo].[Table1] add
> Col1 varchar(20),
> Col2 datetime
> ')' could not be propagated to the subscriber. (Source: MSSQL_REPL,
> Error number: MSSQL_REPL-2147201001)
> Get help: http://help/MSSQL_REPL-2147201001
>
> I've spent quite a bit of time searching for all those errors, codes,
> etc.. nothing helped
> Any suggestions would be appreciated
>

"CrudeOil" <bcomeau@canada.com> wrote in message
news:1148681905.836536.170340@i40g2000cwc.googlegroups.com...
> Hi,
>
> I've added a couple new fields to a table. There are 10 subscriptions
> on this publication. Only 1 has problems synchronizing since. First
> error is:
>
> The merge process could not clean up the subscription to
> 'SERVER':'SERVER:'PUB'. (Source: MSSQL_REPL, Error number:
> MSSQL_REPL-2147200965)
> Get help: http://help/MSSQL_REPL-2147200965
> New request is not allowed to start because it should come with valid
> transaction descriptor. (Source: MSSQLServer, Error number: 3989)
> Get help: http://help/3989
>
> If I reinitialize AND check to upload changes before reinitialize then
> I get
>
> The schema script ' if not exists (select * from syscolumns where name
> = N'NewCol1' and id = object_id(N'[dbo].[Table1]')) if not exists
> (select * from syscolumns where name = N'NewCol2' and id =
> object_id(N'[dbo].[Table1]')) if object_id(N'[dbo].[Table1]') is not
> null exec('ALTER TABLE [dbo].[Table1] add
> Col1 varchar(20),
> Col2 datetime
> ')' could not be propagated to the subscriber. (Source: MSSQL_REPL,
> Error number: MSSQL_REPL-2147201001)
> Get help: http://help/MSSQL_REPL-2147201001
>
> I've spent quite a bit of time searching for all those errors, codes,
> etc.. nothing helped
> Any suggestions would be appreciated
>