SQL Server Errors or Failures from Error: 22571 to Error: 22805

SQLServerF1

 

Error: 22571, Severity: 16, contains one or more articles that use datatypes new in SQL Server 2000
Error: 22572, Severity: 16, contains one or more articles with a timestamp column
Error: 22573, Severity: 16, uses snapshot compression with snapshot_in_defaultfolder set to false
Error: 22574, Severity: 16, contains one or more articles that use vertical partitioning
Error: 22575, Severity: 16, When article property ‘published_in_tran_pub’ is set to ‘true’ then article property ‘upload_options’ has to be set to disable uploads.

Error: 22576, Severity: 10, Invalid failover_mode value of %d was specified for [%s].[%s].[%s], setting to 0 [immediate].
Error: 22578, Severity: 16, Cannot change publication “%s” to disallow use_partition_groups because it contains one or more logical record relationships. When using logical record relationships the publication must set the @use_partition_groups property to ‘true’.
Error: 22579, Severity: 16, The subscription to publication ‘%s’ was not found but a shared agent does exist. To specify a subscription to a publication that is replicated via a shared agent specify ‘%s’ for the publication name.

Error: 22580, Severity: 16, Cannot publish database ‘%s’ because it is marked as published on a different server. Before attempting to publish this database, execute sp_replicationdboption, specifying a value of FALSE for ‘publish’ and ‘merge publish’.
Error: 22581, Severity: 16, Article ‘%s’ cannot be added or modified in publication ‘%s’. The replication of FILESTREAM columns is not supported for publications that have a ‘sync_mode’ of 1 (character mode). Specify a ‘sync_mode’ of 0 (native mode) for the publication by using sp_a
Error: 22582, Severity: 16, Article ‘%s’ cannot be added or modified in publication ‘%s’. The replication of FILESTREAM columns is not supported for publications that have a ‘publication_compatibility_level’ of less than “90RTM” (SQL Server 2005). Specify a ‘publication_compatibilit
Error: 22583, Severity: 16, Article ‘%s’ cannot be added or modified in publication ‘%s’. The replication of FILESTREAM columns is not supported for articles that have a ‘schema_option’ set to 0x20000000. This converts large object data types to data types that are supported on earl
Error: 22584, Severity: 10, Warning: Values of some of the flags specified in the ‘schema_option’ property are not compatible with the publication’s compatibility level. The modified schema_option value of ‘%s’ will be used instead.
Error: 22585, Severity: 10, The schema option to script out the FILESTREAM attribute on varbinary(max) columns has been enabled for article ‘%s’. Enabling this option after the article is created can cause replication to fail when the data in a FILESTREAM column exceeds 2GB and ther
Error: 22586, Severity: 16, Column ‘%s’ cannot be added or modified in article ‘%s’ of publication ‘%s’. The DDL operatoin on hierarchyid and FILESTREAM columns is not supported for publications that have a ‘sync_mode’ of 1 (character mode) or with a lower than 90RTM backward compat
Error: 22801, Severity: 16, Starting the Change Data Capture Collection Agent job. To report on the progress of the operation, query the sys.dm_cdc_log_scan_sessions dynamic management view.
Error: 22802, Severity: 16, Starting the Change Data Capture Cleanup Agent job using low watermark %s.
Error: 22803, Severity: 16, Change Data Capture has scanned the log from LSN{%s} to LSN{%s}, %d transactions with %d commands have been extracted. To report on the progress of the operation, query the sys.dm_cdc_log_scan_sessions dynamic management view.
Error: 22804, Severity: 16, Change Data Capture cannot proceed with the job-related action because transactional replication is enabled on database %s but Distributor information cannot be retrieved to determine the state of the logreader agent. Make the Distributor database availab
Error: 22805, Severity: 10, For more information, query the sys.dm_cdc_errors dynamic management view.

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.

 

Leave a Reply

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