Publication does not exist.

I have an error that states....
DESCRIPTION:Replication-Replication Merge Subsystem: agent R99S-SQLA-
EDI-EDI Merge to 00-r00s-sqla-2 failed. Publication 'EDI Merge to 00'
does not exist.
Due to the fact that there are other consultants setting up/deleteing
replication & do not know how this happened...nonetheless I need to
delete this replication. The publication is not in the tree list in
Local Publications, so I have no way of getting rid of it from there.
I have done some research & I am suppose to look in the
MSmerge_publications table in the distribution dB, but I do not have a
distribution dB.
Any one have a clue about this one?
Larry...
Looks like someone has created a publication from script that has spaces in
the name. You have to delete this publication, and then recreate it
correctly.
You will probably have to edit the system tables to do this.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1185813236.584431.209930@.19g2000hsx.googlegro ups.com...
>I have an error that states....
> DESCRIPTION: Replication-Replication Merge Subsystem: agent R99S-SQLA-
> EDI-EDI Merge to 00-r00s-sqla-2 failed. Publication 'EDI Merge to 00'
> does not exist.
> Due to the fact that there are other consultants setting up/deleteing
> replication & do not know how this happened...nonetheless I need to
> delete this replication. The publication is not in the tree list in
> Local Publications, so I have no way of getting rid of it from there.
>
> I have done some research & I am suppose to look in the
> MSmerge_publications table in the distribution dB, but I do not have a
> distribution dB.
> Any one have a clue about this one?
> Larry...
>