Return
-
Title
Invalid object name 'dbo.sysmergesubscriptions' -
Description
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.
-
Resolution
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