SQL Server Errors or Failures from Error: 22531 to Error: 22550

 

Error: 22531, Severity: 10, Initialization.
Error: 22532, Severity: 10, Upload of Subscriber changes to the Publisher.
Error: 22533, Severity: 10, Download of Publisher changes to the Subscriber.
Error: 22534, Severity: 16, Character mode publication does not support partitioned tables.
Error: 22535, Severity: 16, For heterogeneous publications, the %s parameters should be specified when calling “%s”.

Error: 22536, Severity: 16, The %s parameter value cannot be updated or changed for heterogeneous publications.
Error: 22537, Severity: 16, The job_login provided must match the Publisher login specified when adding the distribution Publisher (sp_adddistpublisher).
Error: 22538, Severity: 16, Only replication jobs or job schedules can be added, modified, dropped or viewed through replication stored procedures.

Error: 22539, Severity: 16, Use of parameters %s is invalid when parameter %s is set to %s.
Error: 22540, Severity: 16, Cannot change publication “%s” to use sync_mode of “character”, because it contains one or more logical record relationships.
Error: 22541, Severity: 16, Cannot add a logical record relationship in publication “%s” because it uses sync_mode of “character” and could have SQL Server Compact Edition subscribers.
Error: 22542, Severity: 16, Invalid value for property @subscriber_upload_options. Valid values are 0 (allow uploads), 1 (disable uploads), 2 (disable uploads prohibit subscriber changes), and 3 (disable_outofpartition_subscriber_changes).
Error: 22543, Severity: 16, When the publication property @allow_partition_realignment is set to “false”, the article property @subscriber_upload_options for all articles in the publication must be set to disable uploads.
Error: 22544, Severity: 10, Warning: The procedure sp_mergecleanupmetadata has been deprecated. In SQL Server 2000 SP1 and later, the merge agent calls sp_mergemetadataretentioncleanup every time it runs, so manual cleanup of metadata is not needed. Ignoring passed-in parameters and
Error: 22545, Severity: 16, Cannot add a logical record relationship in publication “%s” because it allows Web synchronization.
Error: 22546, Severity: 16, Cannot change publication “%s” to allow Web synchronization because it contains one or more logical record relationships.
Error: 22547, Severity: 16, A concurrent snapshot is not allowed for snapshot publications.
Error: 22548, Severity: 16, Vertical partitioning is only allowed for log-based articles.
Error: 22549, Severity: 16, A shared distribution agent (%s) already exists for this subscription.
Error: 22550, Severity: 16, Cannot drop identity column “%s” from the vertical partition when identityrangemanagementoption is set to auto.

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.