duplicate (error) merge agents

We created a couple of subscriptions to our SQL 2005 merge publication.
During the process we had some bizzare things happen. We created the
subscription and tried to run it and it created a merge agent on the server
and then failed. We tried to run it again and it created a new duplicate
merge agent on the server and failed. After about the fifth time we noticed
that it was duplicating the merge agents on the server.
We finally got it completed, but now we have duplicate merge agents on the
server and I can't figure out how to delete the extra ones. In SQL 2000 you
could just rightclick the agent and select delete, but I can't seem to find
the same thing in sql 2005.
Can I just go into one of the replication tables and hand delete the extra
subscriptions? what table would that be?
I hope I made this clear enough, thanks
Ken,
I'd open a support case . The system stored procedure to remove the
subscription (sp_dropmergepullsubscription) is not specific to a particular
merge agent, and I'd be concerned to find out what is causing the duplication
of agents on your system so it can be prevented from occurring again.
Rgds,
Paul Ibison
|||thanks, I may have to do that
"Paul Ibison" wrote:

> Ken,
> I'd open a support case . The system stored procedure to remove the
> subscription (sp_dropmergepullsubscription) is not specific to a particular
> merge agent, and I'd be concerned to find out what is causing the duplication
> of agents on your system so it can be prevented from occurring again.
> Rgds,
> Paul Ibison