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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.