So, I am using Replication monitor, and under one of my publisher nodes, I still see an old publication, which I do not see in SSMS Object explorer. This publication shows a red 'x', and I can't view the properties. I've tried using 'sp_droppublication' at
the publisher, 'sp_dropsubscription' at the publisher, 'sp_droppullsubscription' at the subscriber, and 'sp_subscription_cleanup' at the subscriber.
Any ideas on how to get rid of this? It's making the publisher node show a red 'x' also, which is misleading. Thanks!
View Complete Post