Drop an article through EM

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sammy - 27 Feb 2006 16:01 GMT

Hi is there any way to drop an article in EM which is part of a larger
publication which contains other articles, as the article I wish to drop
appears with the tick next to it in the publications under articles but it
does not allow me to untick this which seems strange. Is this by design and
is my only choice to drop the article through using T-Sql replication commands

thanks for any advice Sammy

Reply to this Message

Hilary Cotter - 27 Feb 2006 16:27 GMT

You have to drop active subscribers to do this.

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi is there any way to drop an article in EM which is part of a larger
> publication which contains other articles, as the article I wish to drop
[quoted text clipped - 5 lines]
>
> thanks for any advice Sammy

Reply to this Message

Paul Ibison - 27 Feb 2006 17:08 GMT

Sammy,

it's possible but only through scripts eg:

exec sp_dropsubscription @publication = 'tTestFNames'
, @article = 'tEmployees'
, @subscriber = 'RSCOMPUTER'
, @destination_db = 'testrep'

exec sp_droparticle @publication = 'tTestFNames'
, @article = 'tEmployees'

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Reply to this Message