I have a merge replication model setup with no errors, yet the data is not EVEN on the subscriber at all, and not in synch? What gives? Any ideas? TIA Edit: I see some errors. First, it says it cannot open the database, which was part of an OLD setup, but the monitor still sees it. I'm actually pointing to another database - maybe there's a conflict? How can I clean up an old publication? Thx!
Check procedure sp_droppublication... check BOL for syntax... http://msdn2.microsoft.com/en-us/library/ms188363.aspx MohammedU. Microsoft SQL Server MVP Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
It depends on the how you confiugred your snapshot for the publication... There are multiple ways... 1. drop and recreate table and copy the data.. 2. Delete matching rows and copy the data... 3. delete all rows and copy the data without drop and recreating the table. etc...
