SQL Server Replication |
|
Needed to remove some orphaned subscriptions.
--query to find subscriptions
-- Run from Subscriber Database
SELECT distinct publisher, publisher_db, publication,
FROM dbo.MSreplication_subscriptions
ORDER BY 1,2,3
EXEC sp_subscription_cleanup @publisher = '<publisher server name>',@publisher_db = '<replicated DB>',@publication = '<subscription to remove>';
--query to find subscriptions
-- Run from Subscriber Database
SELECT distinct publisher, publisher_db, publication,
FROM dbo.MSreplication_subscriptions
ORDER BY 1,2,3
EXEC sp_subscription_cleanup @publisher = '<publisher server name>',@publisher_db = '<replicated DB>',@publication = '<subscription to remove>';