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.