I am using SSMS : For a Sql Server 2005 merge replication publication with
SQL Mobile 2005 subscribers, repeatedly deleting and recreating the
publication has led to a state where SQL is unable to recreate the
publication, and also is not able to create a publication of another table.



The error is "Invalid object name: dbo.sysmergepublications" , and looking
in the Distribution database, dbo.sysmergepublications does not exist.

issue a call to sp_replicationdboption 'DatabaseName','merge publish',false

if you get errors about missing objects create them like this create
sysmergepublications (pk int)
and then try again until you can unpublish it. Then try to recreate it.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]