Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 7 of 11.
In some cases, the SQL Server process might encounter exceptions, asserts, scheduler issues, and so on. In those cases, SQL Server triggers the process by default, to generate a minidump with indirect
Description has already been used. 20026 16 No The publication '%s' does not exist. 20027 16 No The article '%s' does not exist. 20028 16 No The Distributor has not been installed correctly.
Description subscriber. This is for backward compatibility only. 20049 16 No The priority value should not be larger than 100.0.
Description 20069 16 No Cannot validate a merge article that uses looping join filters. 20070 16 No Cannot update subscription row. 20072 16 No Cannot update Subscriber information row. 20073 16 No Ar
Description disallowed until the upgrade completes or the initial snapshot has been successfully applied and it has synchronized with the publisher. 20093 16 No Merge replication upgrade is not comple
Description 20514 10 No A rowcount validation request has been submitted to heterogeneous publisher %s for article %s of publication %s. Validation results will be posted to distribution history. 2051
Description 20533 10 No Replication agents checkup 20534 10 No Detects replication agents that are not logging history actively.
Description 20556 10 No Heartbeats detected for all running replication agents. 20557 10 Yes Agent shutdown. For more information, see the SQL Server Agent job history for job '%s'. 20558 10 No Table
Description 20580 10 No Heartbeats not detected for some replication agents. The status of these agents have been changed to 'Failed'. 20581 10 No Cannot drop server '%s' because it is used as a Distr
Description 20600 10 No Agent profile for skipping data consistency errors. It can be used only by SQL Server Subscribers. 20601 10 No Invalid value specified for agent parameter 'SkipErrors'. 20602 1
Description 20618 16 No You must have CREATE DATABASE permission to attach a subscription database. 20619 16 No Server user '%s' is not a valid user in database '%s'. Add the user account or 'guest' u
Description 20633 16 No Cannot start the partitioned snapshot job. Verify that SQL Server Agent is running on the Distributor.
'Description 20644 16 No Invalid value "%s" specified for the parameter @identityrangemangementoption. Valid values are "auto", "manual", or "none". 20645 16 No The property "%s" cannot be modified for'
Description 20656 16 No The @subset_filterclause parameter cannot reference a computed column. 20657 16 No The value for the @pub_identity_range parameter must be a multiple of the increment for the i
Description 20669 16 No Object referenced by the given @article or @artid '%s' could not be found. 20670 16 No Cannot add, drop, or alter the identity range check constraint for table %s. This constra
Description 20684 16 No Deleted more rows than expected in the batched delete attempt on table %s. Stop and restart the Merge Agent. 20685 16 No Cannot drop the filter '%s' .
Description 20695 16 No Only %ld out of %ld rows were updated in the batched update procedure for table %s; other rows could not be updated because they have been deleted. No action is required, but i
'Description business logic resolver. 20709 10 No The merge process could not clean up the conflict table "%s" for publication "%s". 20710 16 No Incorrect identity range allocation was detected when lo'
Description 20724 16 No Could not find a valid command line for the dynamic snapshot job with job_id '%s' for publication '%s'.
Description 20738 11 No Cannot add article '%s' with sparse column or column set to merge publication since merge replication does not support sparse columns and column set. 20739 16 No The DDL operat
Description 20809 16 No Peer-To-Peer topologies require identical publication names on each publisher.
Description 21000 16 No Cannot subscribe to an inactive publication. 21001 16 No Cannot add a Distribution Agent at the Subscriber for a push subscription.
Description 21019 10 No Distribution agent for subscription added. 21020 10 No no comment specified. 21021 16 No Drop the Distributor before you uninstall replication. 21022 16 No If set 'immediate_sy
Description 21039 16 No The article '%s' contains the destination owner '%s'. Non-SQL Server Subscribers require articles to have the destination owner of NULL. 21040 16 No Publication '%s' does not e
Description configure the linked server properly, and ensure that the login used to connect to the Publisher is in the publication access list.
Description 21077 10 No Deactivated initial snapshot for anonymous publication(s). New subscriptions must wait for the next scheduled snapshot. 21078 16 No Table '%s' does not exist in the Subscriber
Description an administrator with sufficient permissions to perform this operation. 21094 16 No Distribution agent profile with id %d does not exist on this instance. If this instance is in an Availab
Description 21121 16 No Only members of the sysadmin fixed server role and '%s' can drop the pull subscription to the publication '%s'. 21122 16 No Cannot drop the distribution database '%s' because i
Description 21137 16 No This procedure supports only remote execution of push subscription agents. 21138 16 No The 'offload_server' property cannot be the same as the Distributor name. 21139 16 No Cou
Description 21154 16 No Cannot change article '%s'. All articles that are part of a concurrent synchronization publication must use stored procedures to apply changes to the Subscriber. 21155 16 No Ca
Description DB Subscribers can use transformable subscriptions. 21171 16 No Could not find package '%s' in msdb at server '%s'.
Description 21189 16 No The queue for this subscription with queue_id = '%s' is not empty. Run the Queue Reader Agent to make sure the queue is empty before setting mode from [queued] to [immediate].
Description 21209 16 No This step failed because column '%s' does not exist in the vertical partition. 21210 16 No The publication must be immediate_sync type to allow subscription copy. 21211 16 No T
Description 21226 16 No The database '%s' does not have a pull subscription to the specified publication. 21227 16 No The 'offload_server' property cannot be the same as the Subscriber server name. 21
Description 21243 16 No Publisher '%s', publication database '%s', and publication '%s' could not be added to the list of synchronization partners.
Description original Publisher of table '%s'. 21261 16 No The offload server must be specified if the agent for this subscription is to be offloaded for remote execution.
'Description the @type parameter, or modify the view to be schema bound with a unique clustered index. 21278 16 No Cannot publish the source object ''%ls''. The value specified for the @type parameter ("'
Description 21293 10 No Warning: adding updatable subscription for article '%s' may cause data inconsistency as the source table is already subscribed to '%s' 21294 16 No Either @publisher (and @publi
Description subscriptions to this publication. 21313 10 No Subscriber partition validation expression must be NULL for static publications. 21314 10 No There must be one and only one of '%s' and '%s'
Description 880 10 No Failed to startup resilient buffer pool extension because the binary version is incompatible with the persisted version.
Description Snapshot Agent runs has permissions to create a sub-directory under the snapshot folder. 21331 16 No Cannot copy user script file to the snapshot folder at the Distributor (%ls).
Description 21347 16 No Column '%s' cannot be excluded from the vertical partitioning because there is a unique index accessing this column. 21348 16 No Invalid property name '%s'. 21349 10 No Warning
Description 21362 16 No Merge filter '%s' does not exist. 21363 16 No Failed to add publication '%s' to Active Directory. %s 21364 16 No Could not add article '%s' because a snapshot is already genera
In many situations involving these types of errors, repair will result in the deletion of the rows pointing to LOB data and the LOB data itself.
Description 21378 16 No Could not open distribution database %s because it is offline or being recovered. Replication settings and system objects could not be upgraded. Be sure this database is availa
Description 21391 10 No Warning: only Subscribers running SQL Server 2000 or later can synchronize with publication '%s' because it contains schema-only articles. 21392 16 No Row filter(%s) is invalid
'Description 21407 16 No Cannot create the subscription. If you specify a value of "initialize with backup" for the @sync_type parameter, you must subscribe to all articles in the publication by specif'
Description 21425 16 No The @publisher parameter may not be NULL for heterogeneous publishers. 21426 16 No No shared agent subscription exists for publication '%s' and the subscriber/subscriber databa
Description 567 16 No File '%.*ls' is not a recognizable trace file. 568 16 No Encountered an error or an unexpected end of trace file '%.*ls'. 569 16 No The handle that was passed to %ls was invalid.
Description 21486 16 No An error occurred while logging the tracer token history information. The tracer token could not be posted.
Description completed. 21509 10 No Cleanup of merge meta data cannot be performed because some republishers have not quiesced their changes. Cleanup will proceed after all republishers have quiesced t
Description 21526 16 No Article '%s' already belongs to a subscription with a different value for the @lightweight property.
Description 21541 16 No Cannot complete ALTER TABLE command. Do not execute the command 'ALTER TABLE table_name DISABLE TRIGGER ALL' on a published table. Reissue multiple 'ALTER TABLE table_name DISA
Description then add the table as an article again using sp_addarticle. Replication will then add the column to the table. 21567 16 No The call format VCALL cannot be used for the specified article. V
'Description partition groups functionality. Use sp_changemergepublication to set ''use_partition_groups'' to ''true''. 21579 16 No Article "%s" in publication "%s" does not qualify for the partition optio'
Description 21597 16 No The article includes only the rowguidcol column. You must publish at least one other column.
'Description 21611 16 No Cannot drop the distribution Publisher "%s" because it has publications defined. Drop the publications first. 21612 16 No For non-SQL Server Publishers, the value of the @sync_'
Description 21626 16 No Unable to connect to Oracle database server '%s' using the Oracle OLEDB provider OraOLEDB.Oracle. For addition information, see SQL Server in Troubleshooting Oracle Publishers
Description 21639 16 No Heterogeneous publishers can not use trusted connections, set @trusted to false. 21640 16 No Non-SQL Server Publishers do not support a value of 1 for the parameter @thirdparty
Description 21656 16 No The data type mapping for %s does not exist. Verify the list of available mappings by querying msdb.dbo.sysdatatypemappings.
Description 21672 16 No The login '%s' has insufficient authorization to execute this command. 21673 16 No Test connection to publisher [%s] failed. Verify authentication information. 21674 16 No Unab
Description 21688 16 No The current login '%s' is not in the publication access list (PAL) of any publication at Publisher '%s'. Use a login that is in the PAL, or add this login to the PAL. 21689 16
Description 21710 16 No Microsoft SQL Server Subscriber Always Wins Conflict Resolver 21711 16 No Microsoft SQL Server Upload Only Conflict Resolver 21712 16 No Microsoft SQLServer Stored Procedure Re
'Description 21729 16 No The @keep_partition_changes property cannot be set to "true." This is because the @publication_compatibility_level property is set to 90RTM or higher and the @use_partition_gro'
Description 21744 16 No Oracle bidirectional publishing requires parameter '%s' to have a value of '%s'. 21745 16 No Cannot generate a filter view or procedure.
Description only' was specified for the @update_mode parameter of sp_addsubscription. To allow updates, you must drop and then re-create the subscription, specifying a different value for @update_mode
Description the same when the procedure is executed at the Publisher and at the Distributor. 21769 10 No Custom data type mappings are not supported. You must validate the correctness of the mapping.
Description 21782 16 No Cannot add primary key column '%s' to article '%s'. If the Publisher is a non- SQL Server Publisher, the primary key could have violated SQL Server limits for number and length
'Description values: %s. 21796 16 No The property "xactsetjobinterval" must be assigned a value greater than or equal to 0. 21797 16 No Cannot create the agent job. ''%s'' must be a valid Windows login i'
Description installed properly and that sp_add_agent_parameter is invoked with a valid value. 21807 16 No For a .NET Assembly Business Logic Handler, the @resolver_clsid must be specified as NULL. 218
Description 21820 16 No Cannot write to the script file in the snapshot folder at the Distributor (%ls). Ensure that there is enough disk space available.
Description 21836 16 No The distribution agent must be run in single subscription stream mode prior to resetting the subscription xact_seqno. 21837 16 No A replication agent job (%s) for this subscrip
'Description 21852 16 No Peer-to-peer publications do not support %s. Article "%s" currently has %s. This must be changed to continue. 21853 10 No Warning: The "%s" property for %s "%s" has been change'
Description 21865 16 No The '%s' publication property must be either 'true' or 'false'. 21866 16 No The publication property '%s' can only be set to '%s' when the publication property '%s' is set to '
If is called explicitly by a user, the Windows login that the user is running under is used for the connection. If is called by a replication agent from , the Windows login associated with the agent i
Description group associated with this virtual network name, however, does not include the publisher database. 21881 16 No The database '%s' at the redirected publisher '%s' for original publisher '%s
Description redirected publisher to add these subscribers as remote servers. 21894 16 No Unable to configure a linked server to query replica host server '%s': return code = %d.
Description 22001 16 No FreeStaleVersionSpace failed for page %S_PGID for database id '%d'. It will be retired in the next iteration of the version cleaner.
Description 22021 13 No The EX Latch failure occurred on RefreshAllHoBts. 22022 21 No An internal error occurred while getting physical foreign file size. 22023 16 No Used by testshell test in failpoi
Description 22115 16 No Change tracking is enabled for one or more tables in database '%.*ls'. Disable change tracking on each table before disabling it for the database. Use the sys.change_tracking_t
Description 22202 16 No Internal error. Unable to run the remote cs garbage collector. Error Code 22202. 22203 16 No Internal error. Unable to update the blobs table in the catalogDB. Error Code 22203
Description 22224 16 No Internal error. ADW Optimized for Compute storage detected. Unable to retrieve blob. 22225 16 No An internal error (%d, %d) occurred. Please retry the operation. If the problem
Description Version. 22305 16 No A NULL or unexpected value was returned by an ODBC call. 22306 16 No Only CCI tables are allowed in this database version.
Description 22329 16 No Open of Rowset (%I64d) in DB (%d) failed. 22330 16 No RowsetColumn Id (%d) missing in Rowset (%I64d). 22331 16 No Provided Accessor Mode is not supported in Rowset. 22332 16 No
Description 22352 16 No Encountered unexpected error during physical catalog maintenance. Contact Technical Support. 22353 16 No The SQL instances has not been correctly setup to allow this operation.
Description 22374 16 No DDL statements are not allowed in User transactions. 22375 16 No An operation that requires a feature to be enabled was started, but the feature is disabled. Aborting. Contact
Description 22399 17 No Failed Update TxnId of object: '%I64d' by TxnId %I64d. Old TxnId %I64d. 22401 17 No Failed to open internal table.
Description 22422 16 No Failed to initialize a remote connection for an internal component. 22424 16 No %ls is not a supported statement type. 22425 16 No %ls is not a supported option in %ls statemen
Description usage charges the rest of this month. For more details, see https://go.microsoft.com/fwlink/?linkid=2243105&clcid=0x409 . 42120 16 No The connection was denied because the server's Public
Description 22442 16 No Point in time not supported for this statement type 22443 16 No ALTER TABLE RANGE statement failed. The specified table '%.*ls' is not partitioned. 22444 16 No ALTER TABLE RANG
An attempt to write a SQL Server log file periodically gets stuck for approximately 45 seconds. The log write doesn't complete in a timely manner.
Description 22465 16 No Failed to clean up rows for object: '%d'. (HRESULT = 0x%x) 22466 16 No Connection to reserved databases are not allowed. 22467 16 No Failed complete data warehouse maintenance
Description 22483 16 No MAX_SERVICE_OBJECTIVE '%ls' cannot be less than or equal to SERVICE_OBJECTIVE '%ls'. 22484 16 No MAX_SERVICE_OBJECTIVE '%ls' cannot be more than '%ld' times the value of SERVIC
Description 22503 16 No Initializing. 22504 16 No Applying the snapshot to the Subscriber. 22505 16 No The merge completed with no data changes processed. 22506 16 No No data needed to be merged. 2250
Description 22521 10 No Unable to synchronize the row because the row was updated by a different process outside of replication.
Description be caused by many factors; for more information, see https://go.microsoft.com/fwlink/?linkid=2252374 .
Description 22532 10 No Upload of Subscriber changes to the Publisher. 22533 10 No Download of Publisher changes to the Subscriber. 22534 16 No Character mode publication does not support partitioned
Description 22548 16 No Vertical partitioning is only allowed for log-based articles. 22549 16 No A shared distribution agent (%s) already exists for this subscription. 22550 16 No Cannot drop identit
Description max vCore < 1. Please upgrade to a higher Service Objective. 22606 16 No A Managed Identity is required to successfully enable Fabric Mirroring. Please configure either System Assigned Man
Description 22623 16 No sp_rename on %ls is not supported on the 'Microsoft Fabric' platform. 22624 16 No SQL Database on the 'Microsoft Fabric' platform requires tables to have a primary key. 22625 1