June 21, 2011 at 9:43 am
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?
June 21, 2011 at 1:23 pm
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.
June 27, 2011 at 4:07 am
Chuck is right. You cant change this without rebuilding the publication.
July 5, 2011 at 7:57 am
thank you guys, that's what i did.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply