Invalid object name 'dbo.sysmergesubscriptions' (234940)

When attempting to promote a standalone ARS instance to a Publisher, the following error is observed:

Failed to modify the object."CN=<DB Name>,CN=Configuration Databases,CN=Server Configuration,CN=Configuration. Invalid object name 'dbo.sysmergepublications'.

This is occasionally observed after demoting an existing publisher and attempting to re-promote it back to a Publisher.

Run the stored procedure sp_removebreplication against the Active Roles databases. Please be sure to back up the databases before performing any tasks. Example query below:

Use [ARSDataBaseName]

EXEC sp_removedbreplication

go