Cannot drop Subscriber %s. There are subscriptions for it in the publication database %s.
Event Information
According to Microsoft
Cause:
A SQL Server instance that is configured as a Subscriber cannot be removed from the role of Subscriber while there are active subscriptions configured for the instance.
Resolution:
Drop all associated subscriptions before attempting to change the Subscriber status of the SQL Server instance:
1.Execute sp_helpsubscription (Transact-SQL) in the publication database at the Publisher to find subscriptions.
2.Execute sp_dropsubscription (Transact-SQL) in the publication database to drop subscriptions.
