We have a Peer to Peer replication in sql server 2008 R2.We want to remove an article from the replication.What is the safest way to that(through TSQL),
Will that cause any problem for the replication operation?
Removes an article from a merge publication, please try to execute
sp_dropmergearticle at the Publisher on the publication database.
Dropping an article from a publication does not remove the object from the publication database or the corresponding object from the subscription database. For merge publications, the dropping active vary based on the compatibility level.
TechNet Community Support
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?