SQL Server Errors or Failures from Error: 20051 to Error: 20070



Error: 20051, Severity: 16, The Subscriber is not registered.
Error: 20052, Severity: 16, The @metatype parameter value must be null, 1, 2, 5, or 6.
Error: 20053, Severity: 16, An article with a different %s value already exists for object ‘%s’.
Error: 20054, Severity: 16, Current database is not enabled for publishing.
Error: 20055, Severity: 16, Table ‘%s’ cannot be published for merge replication because it has a timestamp column.
Error: 20056, Severity: 16, Table ‘%s’ cannot be republished.

Error: 20057, Severity: 16, The profile name ‘%s’ already exists for the specified agent type.
Error: 20058, Severity: 16, The @agent_type must be 1 (Snapshot), 2 (Logreader), 3 (Distribution), or 4 (Merge)
Error: 20059, Severity: 16, The @profile_type must be 0 (System) or 1 (Custom)
Error: 20060, Severity: 16, Compatibility level cannot be smaller than 60.
Error: 20061, Severity: 16, The compatibility level of this database must be set to 70 or higher to be enabled for merge publishing.

Error: 20062, Severity: 16, Updating columns with the rowguidcol property is not allowed.
Error: 20063, Severity: 16, Table ‘%s’ into which you are trying to insert, update, or delete data has been marked as read-only. Only the merge process can perform these operations.
Error: 20064, Severity: 16, Cannot drop profile. Either it is not defined or it is defined as the default profile.
Error: 20065, Severity: 16, Cannot drop profile because it is in use.
Error: 20066, Severity: 16, Profile not defined.
Error: 20067, Severity: 16, The parameter name ‘%s’ already exists for the specified profile.
Error: 20068, Severity: 16, The article cannot be created on table ‘%s’ because it has more than %d columns.
Error: 20069, Severity: 16, Cannot validate a merge article that uses looping join filters.
Error: 20070, Severity: 16, Cannot update subscription row.

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.

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


Leave a Reply

Your email address will not be published. Required fields are marked *