Drop an article through EM

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
You have to drop active subscribers to do this.
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
"Sammy" <Sammy@.discussions.microsoft.com> wrote in message
news:C9282CFC-CC9E-448D-A1C5-27D4A9284BDA@.microsoft.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
> 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
|||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)