Hi,

Thank you for your reply.

Our msdistribution_agents and msdistribution_history tables are empty.

So what I did was to join msrepl_errors with msmerge_history according to the session_id, and then join again with msmerge_agents

Can I assume that joining on the session_id of these msmerge_history and msrepl_errors is okay?

I'm having doubts because not all session_ids exist in msmerge_history, thus I end up doing a LEFT JOIN.