clearing up replication

Hi
I am trying to clear up replication on our server and under Replication
Monitor\Publishers..there is a publication I want to get rid of as the db no
longer exists. When I try to delete it I get the error msg:-
Error 21766...The name 'abc' was not found in the TransPublications
collection...
I've been trying to find info on how to get rid of this and can't seem to
find anything of use so does anyone have any ideas?
Thanks
JonjoI'm not sure if this helps for you but did you try:
sp_removedbreplication 'dbname'
"jonjo" wrote:
> Hi
> I am trying to clear up replication on our server and under Replication
> Monitor\Publishers..there is a publication I want to get rid of as the db no
> longer exists. When I try to delete it I get the error msg:-
> Error 21766...The name 'abc' was not found in the TransPublications
> collection...
> I've been trying to find info on how to get rid of this and can't seem to
> find anything of use so does anyone have any ideas?
> Thanks
> Jonjo
>
>|||Hi Umut
Yea, I tried that but it tells me the db does not exist..which I knew anyway.
"Umut Nazlica" wrote:
> I'm not sure if this helps for you but did you try:
> sp_removedbreplication 'dbname'
>
> "jonjo" wrote:
> > Hi
> >
> > I am trying to clear up replication on our server and under Replication
> > Monitor\Publishers..there is a publication I want to get rid of as the db no
> > longer exists. When I try to delete it I get the error msg:-
> >
> > Error 21766...The name 'abc' was not found in the TransPublications
> > collection...
> >
> > I've been trying to find info on how to get rid of this and can't seem to
> > find anything of use so does anyone have any ideas?
> >
> > Thanks
> >
> > Jonjo
> >
> >
> >