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:
exec sp_changepublication @publication = ‘SynchPub’,
@property = ‘sync_method’, @value = ‘concurrent’
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?