SQL Server Errors or Failures from Error: 20727 to Error: 20806

 

Error: 20727, Severity: 16, An invalid value was specified for parameter @subscription_type. Valid values are ‘push’, ‘pull’, ‘both’, ‘anonymous’ or ‘all’.
Error: 20728, Severity: 16, Failed to restore the max allocated identity value for article ‘%s’ in publication ‘%s’.
Error: 20729, Severity: 16, The max identity value allocation for article ‘%s’ in publication ‘%s’ could not be found on the distributor.
Error: 20730, Severity: 16, Setting @upload_first to ‘true’ requires the publication to be at publication_compatibility_level of ’80RTM’ or higher. Use sp_changemergepublication to set publication_compatibility_level to ’80RTM’ or higher if you want to use this feature.

Error: 20731, Severity: 16, This edition of SQL Server does not support publications. Dropping existing publications.
Error: 20732, 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: 20733, Severity: 16, One or more rows updated in table ‘%s’ were out of partition while the table was published with ‘partition_options’ set to %d.
Error: 20734, Severity: 16, One or more rows deleted in table ‘%s’ were out of partition while the table was published with ‘partition_options’ set to %d.

Error: 20735, Severity: 16, Cannot add article ‘%s’ to publication ‘%s’. The publication already contains 256 articles, which is the maximum.
Error: 20736, 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: 20737, Severity: 10, Warning: To allow replication of FILESTREAM data to perform optimally and reduce memory utilization, the ‘stream_blob_columns’ property has been set to ‘true’. To force FILESTREAM table articles to not use blob streaming, use sp_changemergearticle to set
Error: 20738, Severity: 11, Cannot add article ‘%s’ with sparse column or column set to merge publication since merge replication does not support sparse columns and column set.
Error: 20739, Severity: 16, The DDL operation is not supported for article ‘%s’. If the column in the DDL operation is enabled for FILESTREAM or is of type hierarchyid, geometry, geography, datetime2, date, time, or datetimeoffset, the publication compatibility level must be at leas
Error: 20800, Severity: 16, Cannot reinitialize the article ‘%s’ in subscription ‘%s:%s’ to publication ‘%s’. The publication is enabled for peer-to-peer transactional replication, which does not allow subscriptions to be reinitialized with a snapshot. Drop and re-create the subscri
Error: 20801, Severity: 16, Cannot reinitialize the subscription. The publication is enabled for peer-to-peer transactional replication, which does not allow subscriptions to be reinitialized with a snapshot. Drop and re-create the subscription instead.
Error: 20802, Severity: 16, Cannot publish objects from the replication administrative user schema [%s]. This schema owns all replication procedures and metadata tables, but it cannot own published objects. Use a different schema for objects that will be published.
Error: 20803, Severity: 16, Peer-To-Peer topologies require identical articles in publications at all nodes prior to synchronizing. Articles in publication [%s].[%s].[%s] do not match articles in [%s].[%s].[%s].
Error: 20804, Severity: 16, Articles can only be included in a single peer-to-peer publication. [%s].[%s] is already included in the peer-to-peer publication ‘%s’.
Error: 20805, Severity: 16, Peer-to-peer topologies require identical publication names on each Publisher. You are attempting to republish object [%s].[%s] that is already being published in the peer-to-peer publication [%s].[%s].[%s].
Error: 20806, Severity: 16, An error occurred while executing a peer-to-peer forwarding command. Contact Customer Support Services.

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.