Cannot mak the change on Publisher's articles

• Ed7

  SSCrazy Eights

  Points: 8516

  More actions

  February 6, 2008 at 1:37 pm

  #182466

  Hello room,

  When I tried to update my publisher's article.

  exec sp_changearticle 'Publisher name', 'table1', 'del_cmd', 'NONE'

  I got the error listed:

  Msg 20608, Level 16, State 1, Procedure sp_MSreinit_article, Line 122

  Cannot make the change because there are active subscriptions. Set @force_reinit_subscription to 1 to force the change and reinitialize the active subscriptions.

  Can anyone advise on this.?

  Thank you.

  TJ

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734522

  More actions

  February 6, 2008 at 8:23 pm

  #775855

  As it says, you can force the subscription by passing in a parameter.

  Here's the entry in BOL: http://technet.microsoft.com/en-us/library/ms175980.aspx

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  February 6, 2008 at 9:14 pm

  #775863

  Hi,

  Try this,Stop the synchronization process and then change the articles in Publisher database.

  I hope this will solve your problem