Removing article from replicated tables(Trnasactional replication)

Hi Everyone,

We have a trnasactional replication in sql server 2008 R2.We want to remove an article from the replication.I am aware that this will invalidate our snapshot.But will this stop the operation of replication.(Generally we do not use snapshot at all).

June 28th, 2013 10:19pm

It should not if you do the following:
use Test_IS_1
GO
exec sp_changepublication MyPublication,'allow_anonymous', false
GO
exec sp_changepublication MyPublication,'immediate_sync', false
GO
exec sp_dropsubscription MyPublication, MyTable, SubscriberServerName, SubscriptionDatabaseName
GO
exec sp_droparticle MyPublication, MyTable

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2013 6:16pm

Thanks for your reply,

But this will drop the subscription.Can I avoid droppping subscription and just drop the article from subscription.

July 1st, 2013 8:45pm

It will just drop the subscription for the one article, not the entire subscription.

Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2013 1:35pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics