February 6, 2008 at 1:37 pm
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
February 6, 2008 at 8:23 pm
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
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 6, 2008 at 9:14 pm
Hi,
Try this,Stop the synchronization process and then change the articles in Publisher database.
I hope this will solve your problem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply