Hi,
I have a subscription on server 1 and it's publication sits on server 2.
Server 2 has been decommissioned and now I want to delete my orphaned subscription on server 1 but I'm not sure how to.
I have tried right click and delete in ssms and also tried sp_subscription_cleanup but none of these have worked (although it says completed successfully).
I'm using Transactional Replication.
How can I delete this orphaned subscription?
Thanks.