Take the 2-minute tour ×
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. It's 100% free, no registration required.

I'm referring to the ones that start with:

dbo.sp_MSdel...
dbo.sp_MSins...
dbo.sp_MSupd...

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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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.