At Stedman Solutions, we do a lot of work with SQL Server replication, mostly transactional and merge replication.
The other day I needed a query to show all the merge replication publication on a SQL Server, not just a single database, but to see it for all databases on the SQL Server.
Here is the query that I came up with.
Merge replication can be really great if you know what you’re doing. But it can also turn into a train wreck easily, and it’s really tough to get a good understanding of why something’s going wrong or how long it will take to be fixed (if at all).