How can a subscriber of one publication also be a publisher of another publication in SQL?
We have a replication on our server which is not initializing because of the following error: "Cannot drop the table  because it is being used for replication."
We found out that the client has set the subscriber on their server as a publisher for another replication.
What is the solution to avoid this error?
All databases involved are SQL Server databases.