SQL Server Errors or Failures from Error: 20009 to Error: 20028



Error: 20009, Severity: 16, The article ‘%s’ could not be added to the publication ‘%s’.
Error: 20010, Severity: 16, The Snapshot Agent corresponding to the publication ‘%s’ could not be dropped.
Error: 20011, Severity: 16, Cannot set incompatible publication properties. The ‘allow_anonymous’ property of a publication depends on the ‘immediate_sync’ property.
Error: 20012, Severity: 16, The subscription type ‘%s’ is not allowed on publication ‘%s’.
Error: 20013, Severity: 16, The publication property ‘%s’ cannot be changed when there are subscriptions on it.

Error: 20014, Severity: 16, Invalid @schema_option value.
Error: 20015, Severity: 16, Could not remove directory ‘%ls’. Check the security context of xp_cmdshel and close other processes that may be accessing the directory.
Error: 20016, Severity: 16, Invalid @subscription_type value. Valid values are ‘pull’ or ‘anonymous’.
Error: 20017, Severity: 16, The subscription on the Subscriber does not exist.

Error: 20018, Severity: 16, The @optional_command_line is too long. Use an agent definition file.
Error: 20019, Severity: 16, Replication database option ‘%s’ cannot be set unless the database is a publishing database or a distribution database.
Error: 20020, Severity: 16, The article resolver supplied is either invalid or nonexistent.
Error: 20021, Severity: 16, The subscription could not be found.
Error: 20022, Severity: 16, This article has now settings to disable uploads and compensate_for_errors=true. However, local and anonymous subscribers will behave as if compensate_for_errors=false.
Error: 20023, Severity: 16, Invalid @subscriber_type value. Valid options are ‘local’, ‘global’, or ‘anonymous’.
Error: 20024, Severity: 16, The alt_snapshot_folder cannot be the same as the working directory.
Error: 20025, Severity: 16, The publication name must be unique. The specified publication name ‘%s’ has already been used.
Error: 20026, Severity: 16, The publication ‘%s’ does not exist.
Error: 20027, Severity: 16, The article ‘%s’ does not exist.
Error: 20028, Severity: 16, The Distributor has not been installed correctly. Could not enable database for publishing.

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 *