I wanted to get a list of SQL merge publications on a given SQL database.

This stored procedure does the business, give it a whirl

exec sp_helpmergepublication