SQL Server Errors or Failures from Error: 21165 to Error: 21184



Error: 21165, Severity: 16, Column ‘%s’ cannot be excluded from a vertical partition because it is neither nullable nor defined with a default value.
Error: 21166, Severity: 16, Column ‘%s’ does not exist.
Error: 21167, Severity: 16, The specified job ID does not represent a %s agent job for any push subscription in this database.
Error: 21168, Severity: 16, Only members of the sysadmin fixed server role, members of the db_owner fixed database role, and owners of subscriptions served by the specified replication agent job can modify the agent offload settings.

Error: 21169, Severity: 16, Could not identify the Publisher ‘%s’ at the Distributor ‘%s’. Make sure that the server ‘%s’ is registered at the Distributor.
Error: 21170, Severity: 16, The specified Subscriber cannot use transformable subscriptions using Data Transformation Services. Only SQL Server 2000, SQL Server 2005, and OLE DB Subscribers can use transformable subscriptions.

Error: 21171, Severity: 16, Could not find package ‘%s’ in msdb at server ‘%s’.
Error: 21172, Severity: 16, The publication has to be in ‘character’, ‘concurrent_c’, or ‘database snapshot character’ bcp mode to allow DTS.
Error: 21173, Severity: 16, The publication has to be ‘independent_agent type’ to allow DTS.
Error: 21174, Severity: 16, Because this publication allows transformable subscriptions using DTS, it requires autogenerated stored procedures and parameterized commands, which are set using default value for the @status.
Error: 21175, Severity: 16, You cannot change the ins_cmd, upd_cmd, or del_cmd article properties because the publication allows Data Transformation Services or updatable subscriptions.
Error: 21176, Severity: 16, Only members of the sysadmin fixed server role, db_owner fixed database role, or the creator of the subscription can change the subscription properties.
Error: 21177, Severity: 16, Could not create column list because it is too long. Create the list manually.
Error: 21178, Severity: 16, Data Transformation Services (DTS) properties cannot be set because the publication does not allow transformable subscriptions using DTS. To allow transformable subscriptions, you must drop the publication and then and re-create it, specifying that transf
Error: 21179, Severity: 16, Invalid @dts_package_location parameter value. Valid options are ‘Distributor’ or ‘Subscriber’.
Error: 21180, Severity: 16, A publication that allows DTS cannot be enabled for updatable subscriptions.
Error: 21181, Severity: 16, @dts_package_name can be set for push subscriptions only.
Error: 21182, Severity: 16, The @agent_type parameter must be one of ‘distribution’, ‘merge’, or NULL.
Error: 21183, Severity: 16, Invalid property name ‘%s’.
Error: 21184, Severity: 16, %s parameter is incorrect: it should be ‘%s’, ‘%s’ or ‘%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 *