How to view subscriptions to a publication

  • Hello all,

    I am attempting to delete a publication in SQL Server 2008. When I attempt to delete it, I receive the error:

    "Could not drop article. A subscription exists on it. (Microsoft SQL Server. Error: 14046)"

    However, there are no subscriptions listed under Replication. When I launch Replication Monitor, Subscription Watch List, there is a subscription listed. However, when I right-click on it, and try to click on Properties or "View Details", it says that the subscription doesn't exist.

    I am hoping that perhaps using a T-SQL command, I can better understand what is happening. Does anyone know how I can use a T-SQL command to view the subscription to the publication, and delete it? I would also appreciate any suggestions that involve the GUI.

    Thanks.

  • I am having the same issue and when i try to remove the subscription is gives an error saying subscription ("The Subscription could not be droped at this time.change database context to Account") is in use in in fact its not. I am using Merge Replication and wondering if this is my issue...either way does anyone have any ideas as how to drop this and start over..i was thinking of just removing the distribution database all together but i am sure there will be something stopping me from that as well. Any ideas?

    DHeath

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply