SQL Server Errors or Failures from Error: 21806 to Error: 21825
Error: 21806, Severity: 16, The agent profile creation process cannot validate the specified agent parameter value: the profile_id %d does not exist or it does not support the parameter %s. The value must be an integer. Verify that replication is installed properly and that sp_add_a
Error: 21807, Severity: 16, For a .NET Assembly Business Logic Handler, the @resolver_clsid must be specified as NULL.
Error: 21808, Severity: 16, For a .NET Assembly Business Logic Handler, the @resolver_info must contain the class name in ‘%s’ that implements the Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule interface.
Error: 21809, Severity: 10, DDL replication is not enabled for database ‘%ls’ because its compatibility level is less than 80.
Error: 21810, Severity: 16, Identity column can only be added to a published table with ‘Not For Replication’ clause
Error: 21811, Severity: 16, Cannot drop the column ‘%s’ because it is used by replication: it is referenced in a filter or view by article ‘%s’. To drop the column, you must first remove the filter from the article.
Error: 21812, Severity: 16, Cannot perform “Disable Trigger All” on table %s because it belongs to a publication that supports updatable subscriptions (replication adds triggers to
tables for these types of publications). You may, however, disable user triggers individually. Specify
Error: 21813, Severity: 16, Can not disable trigger %s on table %s because it is required by updatable publication.
Error: 21814, Severity: 16, DDL replication failed to refresh custom procedures, please run “exec sp_register_custom_scripting ‘CUSTOM_SCRIPT’, your_script, ‘%s’, ‘%s’ “and try again
Error: 21815, Severity: 16, Can not alter replicated object ‘%s’ to ‘with encrypted’.
Error: 21816, Severity: 16, An invalid value was specified for parameter ‘%s’. The value must be ‘%s’ when changing this property.
Error: 21817, Severity: 16, The property ‘%s’ is only valid for push subscriptions.
Error: 21818, Severity: 10, The parameters for security, batch size, and scheduling have been deprecated and should no longer be used. For more information, see the “sp_addsubscriber” documentation.
Error: 21819, Severity: 16, Cannot change the property ‘%s’ . This property is only valid for subscriptions that allow updating at the Subscriber. The subscription against which the procedure was called does not allow updates at the Subscriber.
Error: 21820, Severity: 16, Cannot write to the script file in the snapshot folder at the Distributor (%ls). Ensure that there is enough disk space available. Also ensure that the account under which the Snapshot Agent runs has permissions to write to the snapshot folder and its sub
Error: 21821, Severity: 16, Specify one and only one of the parameters – %s or %s.
Error: 21822, Severity: 16, Cannot perform %s on %s as entry already exists.
Error: 21823, Severity: 16, Cannot perform %s on %s as entry does not exist.
Error: 21824, Severity: 16, Can not add constraints to multiple columns because table %s is published but column %s is not in all active partitions, please use separate DDL statement.
Error: 21825, Severity: 16, Can not drop constraints in the same DDL statement which drops columns from table %s because the table is published, please use separate DDL statement.
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.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.