sql server replication: run sp_droppullsubscription in your subscriber

sp_droppullsubscription
@publisher='Publisher',@publisher_db='Publishing_database',
@publication='Publication'

[quoted text, click to view]

Hello all,

I use to have a named subscription then for an reason I delete it.
Now I am trying to create an new anonymous but I get the following error:

Category:SQLSERVER
Source:
Number: 21500
Message: Invalid subscription type is specified. A subscription to
publication 'myDB' already exists in the database with a different
subscription type.

Do you now any way to delete what remains there?


Thanks in advance,


DP

Thanks for the help,

but unfortunately this is not working says that its doesnt exist ...
I saw that it has created a distribution database ( seems that I was trying
to create a transactional repldb !!!)
I tryed to drop it with sp_dropdistributiondb but it cannot because it has
some publisher

any ideas...

DP

[quoted text, click to view]

Attempting to remove the distribution database directly is not a good idea - it is integral to replication setup. If you want to remove the publication and start again, it can be deleted from the publications folder, or if you really want to remove the distribution database then going to tools, replication, disable publishing will do that and then you have a clean starting point but will have to rebuild all publications. However, from your first post, it sounds like you just want to remove the subscription. Have a look at the properties of the publication and see the list of subscribers there - they can be deleted from the same interface. Also have a look at the subscriptions folder on the subscriber: they can be removed using the interface. Hilary's procedure should also work - did you definitely run it on the subscriber? Anyway, there are a few things to try here and please post back if you have any other problems.
Regards,