How to remove a table from Replication

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Elisabeth Rédei Hall of Fame Points: 3873 More actions · Answer 1

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

Graeme100 SSCrazy Eights Points: 8054 More actions · Answer 2

Hi,

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

Regards

Graeme

steveb. SSC-Forever Points: 46733 More actions · Answer 3

Right click on the publications --> Properties --> Articles

Un-Check the article that you want to stop replicating.

dakshinamurthy-655138 SSCertifiable Points: 5172 More actions · Answer 4

Hi,

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

With Regards

Dakshin

Graeme100 SSCrazy Eights Points: 8054 More actions · Answer 5

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