SQL Server Errors or Failures from Error: 21226 to Error: 21245



Error: 21226, Severity: 16, The database ‘%s’ does not have a pull subscription to the specified publication.
Error: 21227, Severity: 16, The ‘offload_server’ property cannot be the same as the Subscriber server name.
Error: 21228, Severity: 16, The specified source object must be a user-defined function object if it is going to be published as a ‘func schema only’ type article.
Error: 21229, Severity: 16, The schema options available for a view schema article are: 0x00000001, 0x00000010, 0x00000020, 0x00000040, 0x00000100, 0x00001000, 0x00002000, 0x00040000, 0x00100000, 0x00200000, 0x00400000, 0x00800000,

0x01000000, 0x08000000, 0x40000000, and 0x80000000.
Error: 21230, Severity: 16, Do not call this stored procedure for schema change because the current database is not enabled for replication.
Error: 21231, Severity: 16, Automatic identity range support is useful only for publications that allow updating subscribers.
Error: 21232, Severity: 16, Identity range values must be positive integers that are greater than 1.

Error: 21233, Severity: 16, Threshold value must be from 1 through 100.
Error: 21234, Severity: 16, Cannot use the INSERT command because the table has an identity column. The insert custom stored procedure must be used to set ‘identity_insert’ settings at the Subscriber.
Error: 21235, Severity: 16, Article property ‘%s’ can be set only when the article uses automatic identity range management.
Error: 21236, Severity: 16, The subscription(s) to Publisher ‘%s’ does not allow subscription copy or it has not been synchronized.
Error: 21237, Severity: 16, There is a push subscription to Publisher ‘%s’. Only pull and anonymous subscriptions can be copied.
Error: 21238, Severity: 16, This database either is a publisher, or there is a push subscription to publication ‘%s’. Only pull and anonymous subscriptions can be copied.
Error: 21239, Severity: 16, Cannot copy subscriptions because there is no synchronized subscription found in the database.
Error: 21240, Severity: 16, The table ‘%s’ is already published as another article with a different automatic identity support option.
Error: 21241, Severity: 16, The threshold value should be from 1 through 100.
Error: 21242, Severity: 16, Conflict table for article ‘%s’ could not be created successfully.
Error: 21243, Severity: 16, Publisher ‘%s’, publication database ‘%s’, and publication ‘%s’ could not be added to the list of synchronization partners.
Error: 21244, Severity: 16, Character mode publication does not support vertical filtering when the base table does not support column-level tracking.
Error: 21245, Severity: 16, Table ‘%s’ is not part of publication ‘%s’.

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 *