Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION procedure is possible, but the majority of subscribers in this replication will be in disconnected state to perform such operation. When they connect the process to publication will be very busy and have very limited time to achieve...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/replication/archive/2007/09/11/1975.aspx