drop subscriptions

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@.NOSPAMhotmail.com> wrote in message
news:ePyf4TS%23EHA.3616@.TK2MSFTNGP11.phx.gbl...
> 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.
>
|||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@.gmail.com> escribi en el mensaje
news:exdnkkS%23EHA.1076@.TK2MSFTNGP10.phx.gbl...
> 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@.NOSPAMhotmail.com> wrote in message
> news:ePyf4TS%23EHA.3616@.TK2MSFTNGP11.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@.NOSPAMhotmail.com> wrote in message
news:%23$xWFoS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> 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@.gmail.com> escribi en el mensaje
> news:exdnkkS%23EHA.1076@.TK2MSFTNGP10.phx.gbl...
>