SQL Server Errors or Failures from Error: 21826 to Error: 21846
Error: 21826, Severity: 16, The property ‘%s’ is valid only for %s subscriptions. Use ‘%s’ for %s subscriptions.
Error: 21827, Severity: 16, The %s parameters have been deprecated and should no longer be used. For more information, see the ‘%s’ documentation.
Error: 21828, Severity: 16, The proxy account for jobstep_uid (%s) could not be found.
Error: 21830, Severity: 16, You cannot specify schema_option 0x4 (script identity as identity rather than the base data type) for article ‘%s’. The value specified for the parameter @identityrangemanagementoption is NONE. To replicate identity as identity, the
value must be MANUAL o
Error: 21831, Severity: 16, The %s already exists. Use ‘%s’ to change any settings/properties.
Error: 21832, Severity: 16, Only members of the sysadmin fixed server role can perform this operation without specifying %s.
Error: 21833, Severity: 16, An error occurred when creating a trace event at Oracle publisher ‘%s’. The trace event could not be posted.
Error: 21834, Severity: 16, The primary key for ‘%s.%s’ has %d columns. SQL Server supports a maximum of %d columns. Redefine the primary key so that it has no more than
the maximum number of columns.
Error: 21835, Severity: 16, The index for the primary key ‘%s.%s’ is at least %d bytes. SQL Server supports a maximum key length of %d bytes. Reduce the number of columns in the primary key or redefine the columns to use smaller data types.
Error: 21836, Severity: 16, The distribution agent must be run in single subscription stream mode prior to resetting the subscription xact_seqno.
Error: 21837, Severity: 16, A replication agent job (%s) for this subscription already exists.
Error: 21838, Severity: 16, The %s parameter(s) have been deprecated from this procedure. The value(s) should now be specified when calling ‘%s’.
Error: 21839, Severity: 16, Article ‘%s’ can not support schema_option 0x20 or 0x2000000000 because it contains computed column, check/default constraint or primary key which is based on CLR type column, change @schema_option setting and try again.
Error: 21840, Severity: 16, Can not add CLR type based computed column or check constraint to table ‘%s’ because article ‘%s’ supports schema_option 0x20.
Error: 21841, Severity: 10, DDL replication is forcing reinitialization because either publication’%s’ uses character mode bcp, or timestamp/identity column is being replicated as base type only for article ‘%s’.
Error: 21842, Severity: 16, %s can only be specified/changed for heterogeneous publications when %s is set to %s.
Error: 21843, Severity: 16, Article ‘%s’ can not be added, an indexed view published as ‘indexed view logbased’ and a stored procedure in either form of ‘proc exec’ can not be published if their common base table is also published.
Error: 21844, Severity: 16, Can not alter XML, CLR type or MAX type column because table is published and article ‘%s’ supports the schema option to map this to a base column type.
Error: 21845, Severity: 16, Can not alter procedure ‘%s’ to depend on an indexed view published as ‘indexed view logbased’ or a base table because the indexed view depends on this table as well.
Error: 21846, Severity: 16, Cannot find a distribution agent job for the specified transactional or snapshot push subscription.
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.