SQL Server Errors or Failures from Error: 20072 to Error: 20500

 

Error: 20072, Severity: 16, Cannot update Subscriber information row.
Error: 20073, Severity: 16, Articles can be added or changed only at the Publisher.
Error: 20074, Severity: 16, Only a table object can be published as a “table” article for merge replication.
Error: 20075, Severity: 16, The ‘status’ parameter value must be either ‘active’ or ‘unsynced’.
Error: 20076, Severity: 16, The @sync_mode parameter value must be ‘native’ or ‘character’.

Error: 20077, Severity: 16, Problem encountered generating replica nickname.
Error: 20078, Severity: 16, The @property parameter value must be one of the following: ‘sync_type’, ‘priority’, ‘description’, ‘subscriber_security_mode’, ‘subscriber_login’, ‘subscriber_password’, ‘publisher_security_mode’, ‘publisher_login’, ‘publisher_password’, ‘merge_job_login
Error: 20079, Severity: 16, Invalid @subscription_type parameter value. Valid options are ‘push’, ‘pull’, or ‘both’.

Error: 20081, Severity: 16, Publication property ‘%s’ cannot be NULL.
Error: 20084, Severity: 16, Publication ‘%s’ cannot be subscribed to by Subscriber database ‘%s’.
Error: 20086, Severity: 16, Publication ‘%s’ does not support the nosync type because it contains a table that does not have a rowguidcol column.
Error: 20087, Severity: 16, You cannot push an anonymous subscription.
Error: 20088, Severity: 16, Only assign priorities that are greater than or equal to 0 and less than 100.
Error: 20089, Severity: 16, Could not get license information correctly.
Error: 20090, Severity: 16, Could not get version information correctly.
Error: 20091, Severity: 16, sp_mergesubscription_cleanup is used to clean up push subscriptions. Use sp_dropmergepullsubscription to clean up pull or anonymous subscriptions.
Error: 20092, Severity: 16, Table ‘%s’ into which you are trying to insert, update, or delete data is currently being upgraded or initialized for merge replication. On the publisher data modifications are disallowed until the upgrade completes and snapshot has successfully run. On s
Error: 20093, Severity: 16, Merge replication upgrade is not complete until the snapshot agent is run for the publisher and the merge agent run for all the subscribers.
Error: 20100, Severity: 16, Cannot drop Subscriber ‘%s’. There are existing subscriptions.
Error: 20500, Severity: 16, The updatable Subscriber stored procedure ‘%s’ does not exist.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.