Hello,
Need a bit of advice, I'm dealing with removing and then recreating a subscription from merge replication.
So far the plan is...(pull subscription)
exec sp_dropmergesubscription at the publisher, then delete it from the subscriber.
check the SYSMERGEARTICLES, SYSMERGEPUBLICATIONS, AND SYSMERGESUBSCRIPTIONS tables, if there are any entries, then truncate these tables (there is only 1 merge rep setup on the database)
Truncate all the tables in the subscription database, to clear it out and start again.
In order to clean up properly, I thought it would be a good idea to truncate all the MsMerge tables, is this a good idea? And is there a script out there to do it, I have had a good look and cant find one.
I thought about using the sp_MSforeachtable SP, but I really think this will not work at all. Am I even operating along the right lines?
Of course if anyone out there can suggest something better, then it would be gratefully received. Quite new to merge, so lacking some experience here.
Regards,
D.