SQL Server Errors or Failures from Error: 14100 to Error: 14121

SQLServerF1

 

Error: 14100, Severity: 16, Specify all articles when subscribing to a publication using concurrent snapshot processing.
Error: 14101, Severity: 16, The publication ‘%s’ already has a Snapshot Agent defined.
Error: 14102, Severity: 16, Specify all articles when unsubscribing from a publication using concurrent snapshot processing.
Error: 14103, Severity: 16, Invalid “%s” value. Valid values are “publisher”, “subscriber”, or “both”.
Error: 14105, Severity: 10, You have updated the distribution database property ‘%s’ successfully.

Error: 14106, Severity: 16, Distribution retention periods must be greater than or equal to 0.
Error: 14107, Severity: 10, The @max_distretention value must be larger than the @min_distretention value.
Error: 14108, Severity: 10, Removed %ld history records from %s.
Error: 14109, Severity: 10, The @security_mode parameter value must be 0 (SQL Server Authentication) or 1 (Windows Authentication).
Error: 14110, Severity: 16, For stored procedure articles, the @property parameter value must be ‘description’, ‘dest_table’, ‘dest_object’, ‘creation_script’, ‘pre_creation_cmd’, ‘schema_option’, or ‘destination_owner’.

Error: 14111, Severity: 16, The @pre_creation_cmd parameter value must be ‘none’ or ‘drop’.
Error: 14112, Severity: 16, This procedure can be executed only against table-based articles.
Error: 14113, Severity: 16, Could not execute ‘%s’. Check ‘%s’ in the install directory.
Error: 14114, Severity: 16, The server ‘%s’ is not configured as a Distributor.
Error: 14115, Severity: 16, The property parameter value must be %s.
Error: 14117, Severity: 16, ‘%s’ is not configured as a distribution database.
Error: 14118, Severity: 16, A stored procedure can be published only as a ‘serializable proc exec’ article, a ‘proc exec’ article, or a ‘proc schema only’ article.
Error: 14119, Severity: 16, Could not add the distribution database ‘%s’. This distribution database already exists.
Error: 14120, Severity: 16, Could not drop the distribution database ‘%s’. This distributor database is associated with a Publisher.
Error: 14121, Severity: 16, Could not drop the Distributor ‘%s’. This Distributor has associated distribution databases.

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 *