Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to remove a table from Replication Expand / Collapse
Author
Message
Posted Sunday, November 2, 2008 10:10 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 330, Visits: 961
Hi,

How to remove a table from Replication, using SQL server, Merge Replication


With Regards
Dakshina
Post #595641
Posted Monday, November 3, 2008 2:04 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 4:08 AM
Points: 175, Visits: 742
Hi Dakshina,

You mean article? See sp_dropmergearticle in BoL.

HTH!

/Elisabeth


elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
Post #595671
Posted Friday, November 7, 2008 7:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 6:46 AM
Points: 1,221, Visits: 683
Hi,

If I remember correctly, you can only do this if there is no subscriber.

Regards
Graeme



Post #598953
Posted Friday, November 7, 2008 8:00 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, May 30, 2014 6:27 PM
Points: 2,808, Visits: 7,175
Right click on the publications --> Properties --> Articles

Un-Check the article that you want to stop replicating.
Post #598968
Posted Saturday, November 8, 2008 4:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:24 AM
Points: 330, Visits: 961
Hi,

I tried with right clicking the article and unchecking it, but we cant uncheck the article.


With Regards
Dakshin
Post #599424
Posted Wednesday, December 10, 2008 1:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 6:46 AM
Points: 1,221, Visits: 683
Use procedures to do this.

Drop the subscribers to the Article...sp_Dropsubscribers..is that the one ?

Drop the Article from the publication...sp_DropArticle..

G



Post #616744
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse