Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm referring to the ones that start with:


I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run sp_removedbreplication on the subscriber (on the database). I also tried sp_subscription_cleanup to no avail.

Do these have to be deleted manually if I want them removed?

Subscriber is SQL 2000
Publisher is SQL 2008 (Distribution database is on the Publisher)

share|improve this question

When you remove a subscription nothing is done to the subscriber. You'll need to remove these procedures manually. They are safe to remove is replication has been removed.

share|improve this answer

When dealing with SQL 2000 replication, the replication bits does not get cleaned up easily. You can follow this method for cleaning up the left over bits.

As Denny mentioned, they are safe to remove as the replication is already removed.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.