Change 'sync_method' in publication

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  June 21, 2011 at 9:43 am

  #389799

  hi guys i have a transactional replication with two active pull subscriptions. I am trying to change one of the parameters for my publication @sync_method = N'concurrent', i have tried running this in the publisher:

  USE DistDB

  exec sp_changepublication @publication = 'SynchPub',

  @property = 'sync_method', @value = 'concurrent'

  GO

  but i keep getting:

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

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

  I am confused because i checked my articles in my publication but they all have @force_invalidate_snapshot = 1, @force_reinit_subscription = 1

  and i reinitialized the active subscriptions but i keep getting the same error

  Can someone tell me what else is needed to make this change?

• Chuck Hottle

  SSCarpal Tunnel

  Points: 4777

  More actions

  June 21, 2011 at 1:23 pm

  #1342078

  I don't believe that you can change this. I think that I looked into it recently and the only option seemed to be dropping and creating the publication.

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  June 27, 2011 at 4:07 am

  #1344376

  Chuck is right. You cant change this without rebuilding the publication.

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  July 5, 2011 at 7:57 am

  #1348290

  thank you guys, that's what i did.