SQL Server Errors or Failures from Error: 21206 to Error: 21225



Error: 21206, Severity: 16, Cannot resolve load hint for object %d because the object is not a user table.
Error: 21207, Severity: 16, Cannot find source object ID information for article %d.
Error: 21208, Severity: 16, This step failed because column ‘%s’ exists in the vertical partition.
Error: 21209, Severity: 16, This step failed because column ‘%s’ does not exist in the vertical partition.
Error: 21210, Severity: 16, The publication must be immediate_sync type to allow

subscription copy.
Error: 21211, Severity: 16, The database is attached from a subscription copy file without using sp_attach_subscription. Drop the database and reattach it using sp_attach_subscription.
Error: 21212, Severity: 16, Cannot copy subscription. Only single file subscription databases are supported for this operation.
Error: 21213, Severity: 16, Subscribers cannot subscribe to publications that allow DTS

without using a DTS package.
Error: 21214, Severity: 16, Cannot create file ‘%s’ because it already exists.
Error: 21215, Severity: 16, An alternate synchronization partner can be configured only at the Publisher.
Error: 21216, Severity: 16, Publisher ‘%s’, publisher database ‘%s’, and publication ‘%s’ are not valid synchronization partners.
Error: 21217, Severity: 10, Publication of ‘%s’ data from Publisher ‘%s’.
Error: 21218, Severity: 16, The creation_script property cannot be NULL if a schema option of 0x0000000000000000 is specified for the article.
Error: 21219, Severity: 16, The specified source object must be a stored procedure object if it is published as a ‘proc schema only’ type article.
Error: 21220, Severity: 16, Unable to add the article ‘%s’ because a snapshot has been generated for the publication ‘%s’.
Error: 21221, Severity: 16, The specified source object must be a view object if it is going to be as a ‘view schema only’ type article.
Error: 21222, Severity: 16, The schema options available for a procedure, function, synonym, or aggregate schema article are: 0x00000001, 0x00000020, 0x00001000, 0x00002000, 0x00400000, 0x02000000, 0x08000000, 0x10000000, 0x20000000, 0x40000000, and 0x80000000.
Error: 21223, Severity: 16, The @pre_creation_command parameter for a schema only article must be either ‘none’ or ‘drop’.
Error: 21224, Severity: 16, ‘%s’ is not a valid property for a schema only article.
Error: 21225, Severity: 16, The ‘offload_server’ property cannot be NULL or empty if the pull subscription agent is to be enabled for remote activation.

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 *