"jughead" <mike.aarset@gmail.com> wrote in message
news:1176965268.535472.269400@b58g2000hsg.googlegroups.com...
>I have been messing around with Replication on MS Virtual Server.
> Set up a Distributor on a seperate machine from the publication
> database.
>
> For some reason unkown my Distribution database went in Suspect Mode.
> Finally got rid of it using
> sp_dropdistributiondb @database = 'distribution'
>
> Now I can't get delete any of my publications.
> They still look towards my Distribution database which is no longer a
> distributor
>
> tried
>
> exec sp_dropsubscription
> @publication='AdventureWorksCentralPublication',@article='all',@subscriber='all',
> @ignore_distributor=1
>
> sp_removedbreplication
>
> SHould I just re-set up my Distributor again and leave the
> publications? Would that even work?
> THere has to be some way to delete my publications
>
> Thanks
> Mike
>

On Apr 19, 5:27 am, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> Did you follow the steps outlined here?
>
> http://support.microsoft.com/kb/324401
>
> "jughead" <mike.aar...@gmail.com> wrote in message
>
> news:1176965268.535472.269400@b58g2000hsg.googlegroups.com...
>
>
>
> >I have been messing around with Replication on MS Virtual Server.
> > Set up a Distributor on a seperate machine from the publication
> > database.
>
> > For some reason unkown my Distribution database went in Suspect Mode.
> > Finally got rid of it using
> > sp_dropdistributiondb @database =3D 'distribution'
>
> > Now I can't get delete any of my publications.
> > They still look towards my Distribution database which is no longer a
> > distributor
>
> > tried
>
> > exec sp_dropsubscription
> > @publication=3D'AdventureWorksCentralPublication',@article=3D'all',@sub=
scriber=3D=AD'all',
> > @ignore_distributor=3D1
>
> > sp_removedbreplication
>
> > SHould I just re-set up my Distributor again and leave the
> > publications? Would that even work?
> > THere has to be some way to delete my publications
>
> > Thanks
> > Mike- Hide quoted text -
>
> - Show quoted text -