Cannot delete merge publication -- sql server replication

dw
5/30/2005 3:06:02 PM

Hello...

I had a merge publication that I thought was removed....at least it does not
appear in Ent. Mgr under the list of Publications. However, in the
Replication Monitor the publication still exists. When I click on the
publication to delete or check its properties I get the mesage:
SQL Server could not retrieve information about publication 'My_Publication'
Error 21776: [SQL-DMO] The name 'My_Publication' was not found in the
MergePublications collection. If the name is a qualified name...'

I searched for that error code...but could not find anything that would help
me solve this problem.

if anyone has any ideas, it would be appreciated.

thanks

Hilary Cotter
5/30/2005 8:31:00 PM

check sysmergepublications in the publications database. Do you find the
publication there?

If so you will need to delete it and the matching sysmergearticles columns.

Also delete the rows for this publication from
distribution.dbo.MSpublications

--
Hilary Cotter
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
[quoted text, click to view]

sql server replication : Cannot delete merge publication