Drop Article from Trans Repl -- sql server replication

Chris
8/25/2006 10:33:01 PM

SQL2000 sp4 - Transactional Replication - remote distributor, 5 subscribers
all SQL2000 Std Ed.

I execute the following sp_dropsubscription:

exec sp_dropsubscription @publication = 'MyPub'
, @article = 'MyTable
, @subscriber = 'all'

I execute the following sp_droparticle:

exec sp_droparticle @publication = 'MyPub'
, @article = 'MyTable'

After 6 months of this working, I am now getting an error:

Server: Msg 14046, Level 16, State 1, Procedure sp_droparticle, Line 265
Could not drop article. A subscription exists on it.

How do I clean this up and allow for sp_droparticle for table maintenance?

Thanks,

Hilary Cotter
8/26/2006 9:19:56 AM

query the table MSreplication_subscriptions on the subscriber. Evaluate
whether this is the problem subscription and if so delete it. Also delete
any corresponding rows in MSsubscription_agents and MSsubscription_articles

--
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

[quoted text, click to view]

sql server replication : Drop Article from Trans Repl