Thanks for the reply - at least I know someone is reading the message 🙂 I had kinda discovered that Enterprise Manager worked that way - but I keep...

I had exactly the same problem recently, and with some help created a script that can detect the stopped merge agent and restart it.

I have posted the script in a...

In case it helps anyone else, here is my completed script to check the status of the merge replication agent (that was started when the SQL Server Agent started -...

Thanks for all the replies,

Using the OPENROWSET method worked nicely.

 Note: the 'set fmtonly off' part of the command is necessary; the default in this case appears to be 'ON' which is...