sql server replication: Hello,

I'm currently getting the following error message when trying to synchronize
my Distributor database server (Server B) to my Main database server (Server
A) using a Merge publication - the publication & subscription did appear to
set up correctly but on the first synchronize I see this:

"Cannot drop procedure 'dbo.MSmerge_ctf_sp_...' because it is being used for
replication.

The merge process was unable to deliver the snapshot to the subscriber" etc.


I have recently removed several subscriptions & publications as part of
testing, so I have a feeling this may be causing a problem - any help
appreciated if you know a work around for this error.

On the subscriber can you run sp_removedbreplication (assuming it isn't
involved as a publisher or subscriber to another publication). Then try
running the merge agent.
HTH,
Paul Ibison