Hi all,

How can I remove a list of subscriptions from the server?


My server acts as PUBLISHER and SUBSCRIBER at the same time, but both
features has been disabled. So, I can't delete the subscriptions list
because I have no PUBLISHER and SUBSCRIBER now.


I've tryied with differents commands like sp_dropsubscriptions,
sp_dropsubscriber, etc, but nothing works.



Is there any way to drop all this trash?



thanks.

Can you enable the databases for publishing and then remove them?

If there are no live subscriptions you can merely delete the contents of
MSreplication_subscriptions and MSsubscription_agents if you have
transactional replication.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JG Espinoza" <jasiele (AT) NOSPAMhotmail (DOT) com> wrote

I can enable the database but i can't delete it as well.


How can I delete the content of MSreplication_subscriptions and
MSsubscription_agents?


I have both transactional and merge subscriptions.




Thanks for your help.



"Hilary Cotter" <hilary.cotter (AT) gmail (DOT) com> escribió en el mensaje
news:exdnkkS%23EHA.1076 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

As the databases aren't used for publications or
subscriptions, you could use sp_removedbreplication.
Regards,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

My above answer about enabling and disabling the databases for publication
was a bad one.

For transactional all you have to do is

delete from MSreplication_subscriptions

or

delete from MSsubscription_agents

To get rid of merge publication metadata use this script

http://groups-beta.google.com/group/...4?dmode=source

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"JG Espinoza" <jasiele (AT) NOSPAMhotmail (DOT) com> wrote