Removing Articles

I want to remove all articles from a subcription and publication. Will these
two commands do it for me?
EXEC sp_dropsubscription @.publication = 'EMOBILE_OLTP_OLAP', @.article =
'all', @.subscriber = 'all', @.destination_db = 'all'
EXEC sp_droparticle @.publication = 'EMOBILE_OLTP_OLAP', @.article = 'all',
@.force_invalidate_snapshot = 1
Thanks,
Mark
Yes, but why not just drop the publication after dropping the subscription?
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
"mrprice" <mrprice@.discussions.microsoft.com> wrote in message
news:985F6D57-2A8C-41C1-A2D7-31B60239DE0B@.microsoft.com...
>I want to remove all articles from a subcription and publication. Will
>these
> two commands do it for me?
> EXEC sp_dropsubscription @.publication = 'EMOBILE_OLTP_OLAP', @.article =
> 'all', @.subscriber = 'all', @.destination_db = 'all'
> EXEC sp_droparticle @.publication = 'EMOBILE_OLTP_OLAP', @.article = 'all',
> @.force_invalidate_snapshot = 1
> Thanks,
> Mark
|||I do that after the sp_droparticle. This is kind of how SQL Enterpise
Manager scipted it out so ...
Mark
"Hilary Cotter" wrote:

> Yes, but why not just drop the publication after dropping the subscription?
> --
> 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
>
> "mrprice" <mrprice@.discussions.microsoft.com> wrote in message
> news:985F6D57-2A8C-41C1-A2D7-31B60239DE0B@.microsoft.com...
>
>