February 11, 2009 at 10:48 pm
All,
SQL Server 2000 SP4, Transactional Replication
I am trying to remove an article from replication so that the schema can be modified and then I will re-insert the article back into replication. I have gone through this process many times in the past with no issues at all. However, this time, when I try to remove the tables from replication, I get the following error message for each table:
Msg 14046, Level 16, State 1, Procedure sp_droparticle....
Could not drop article. A subscription exists on it.
Here is the procedure that I use:
sp_dropsubscription ...
sp_droparticle ... (error is after this one)
modify object/article
sp_addarticle ...
sp_addsubscription ...
My frustration is that I have tried everything in my power to see what other subscription is hanging on to this article to keep me from removing it from replication. Any and all help on this would be great!!!
Thanks again,
Ben
February 11, 2009 at 10:54 pm
In the publication properties, on the subscription tab, what subscriptions are there? Is it what you expected?
February 11, 2009 at 11:01 pm
Fortunately yes. The only Subscription that should be there is the only one there. Still having the issues though. Can't drop the article b/c it is still showing to he attached to another subscription somehow.
Thanks,
Ben
September 19, 2011 at 6:21 am
Have same problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply