Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 5 of 11.
Description 12457 16 Yes Query with query_id %d has forced plan. No hints can be applied to it while it has forced plan. 12458 16 Yes Query with query_id %d has query store hints.
Description 12504 16 No Distribution column '%.*ls' must be implicitly or explicitly specified in the INSERT SELECT query as the target table '%.*ls' is a hash distributed table. 12505 16 No 'Distribu
Description database. The retention period defined for this database is %d days. 12523 16 No The specified point-in-time is invalid. The timestamp must not be after the current snapshot time. 12524 16
Description 12619 16 No The database has too long file path to create clone. 12620 10 No Database cloning for '%.*ls' has started with target as '%.*ls'.
'Description 12709 16 No Structure of JSON with S3 connection options is not correct. Cannot get subobject "s3". 12710 16 No S3 URL style option ''%ls'' is not supported. Please use Path or Virtual_Hoste'
Description 12815 16 No The column referenced as '%.*ls' resolves differently in the target metadata collation '%.*ls' than in the current metadata collation '%.*ls'.
Description 12829 16 No The stored procedure '%.*ls' refers to a group of numbered stored procedures. Numbered stored procedures are not available in contained databases. Please consult the Books Onli
Description 12839 16 Yes Replication, Change Data Capture, Change Feed and Change Tracking are not supported in contained databases. The option cannot be enabled on the contained database '%s'. 12840
Description 13001 16 No file name 13002 16 No audit 13003 16 No audit specification 13004 16 No audit name 13005 16 No server role 13006 16 No server principal 13008 0 No receive 13010 0 No read 13012
Description 13029 0 No table 13030 0 No database 13031 0 No procedure 13032 0 No trigger 13033 0 No view 13034 0 No default 13035 0 No rule 13036 0 No system table 13037 0 No unknown type 13038 0 No S
Description 13099 0 No communication buffer 13100 0 No Common Language Runtime critical section 13101 0 No partition scheme 13102 10 No DETACH 13103 0 No protocol version 13104 0 No RANGE 13105 0 No c
Description 13125 16 No execute as 13126 16 No symmetric key 13127 16 No principal 13128 16 No security descriptor 13129 16 No hypothetical index 13130 16 No nonclustered index 13131 16 No credential
Description 13176 0 No component 13177 16 No IL compilation 13178 16 No Inproc data access 13179 16 No DDL operations 13180 16 No execution cache cleanup 13181 16 No unspecified operation 13182 16 No
Description 13201 10 No security header timestamp 13202 10 No TO BROKER INSTANCE 13203 10 No TO SERVICE 13204 10 No FROM BROKER INSTANCE 13205 10 No FROM SERVICE 13206 10 No SERVICE CONTRACT 13207 10
Description 13227 10 No to 13228 10 No from 13229 10 No enable 13230 10 No disable 13231 10 No remap 13232 10 No INSERT 13233 10 No UPDATE 13234 10 No DELETE 13235 10 No WHEN MATCHED 13236 10 No WHEN
Description 13252 10 No type table 13254 10 No event 13255 10 No target 13256 10 No event action 13257 10 No event session 13258 10 No event package 13259 10 No event object 13260 10 No event predicat
Description 13279 10 No decryption failure (expected: 0x%08x; actual: 0x%08x) 13280 10 No unable to decrypt page due to missing DEK 13281 10 No CREATION_DISPOSITION 13282 10 No PROVIDER_KEY_NAME 13283
Description 13306 10 No DESIRED_STATE' or 'OPERATION_MODE 13307 10 No MAX_STORAGE_SIZE_MB 13308 10 No FLUSH_INTERVAL_SECONDS' or 'DATA_FLUSH_INTERVAL_SECONDS 13309 10 No QUERY_STORE CLEANUP_POLICY 133
Description 13332 10 No maximum 13333 10 No total 13334 10 No Certificate chain validation failed 13335 10 No Certificate does not have subject alternative name 13336 10 No There is no trusted issuer
Description 13391 10 No Location: 13392 10 No Location relative to the specified target node: 13393 10 No search property list 13394 10 No MERGE 13395 10 No PAD_INDEX 13396 10 No FILLFACTOR 13397 10 N
Description development work, and plan to modify applications that currently use it. 13407 10 No FASTFIRSTROW hint will be removed in the next version of SQL Server.
Description 13512 16 No You cannot specify SYSTEM_VERSIONING clause more than once. 13513 16 No SYSTEM_TIME period columns cannot have different datatype precision. 13514 16 No History table '%.*ls' i
Description 13527 16 No Setting SYSTEM_VERSIONING to ON failed because column '%.*ls' does not have the same CLR type in tables '%.*ls' and '%.*ls'. 13528 16 No Setting SYSTEM_VERSIONING to ON failed
Description 13543 16 No Setting SYSTEM_VERSIONING to ON failed because history table '%.*ls' contains invalid records with end of period set to a value in the future. 13544 16 No Temporal FOR SYSTEM_T
Description 13561 16 No Cannot update rows in a temporal history table '%.*ls'. 13562 16 No Cannot perform MERGE operation on temporal history table '%.*ls'. 13563 16 No Enabling Change Tracking for a
Description 13580 16 No Setting SYSTEM_VERSIONING to ON failed because history table '%.*ls' has ROWGUID column specification. Consider dropping all ROWGUID column specifications and trying again. 135
Description 13597 16 No Temporal SYSTEM_TIME period is already defined on table '%.*ls'. 13598 16 No Temporal SYSTEM_TIME period cannot be defined on history table '%.*ls'. 13599 16 No Period column '
Description 13614 16 No TEXT, NTEXT, SQL_VARIANT and IMAGE types cannot be used as column types in OPENJSON function with explicit schema. These types are not supported in WITH clause. 13615 16 No OPE
Description JSON type. 13642 20 No Encountered an unsupported version of the JSON type. Please run DBCC CHECKTABLE with EXTENDED_LOGICAL_CHECKS to identify the rows. The remedy is to delete the rows a
Description 13664 16 No JSON path not valid for JSON index. 13665 16 No %s not yet supported for JSON native data type. 13666 16 No %s does not support CLR type as parameters 13667 16 No JSON aggregat
Description 13685 16 No A JSON index '%.*ls' cannot be found on column '%.*ls' on table '%.*ls'. 13686 16 No Json_Contains matches pattern as LIKE. The pattern should be no longer than 4000 characters
Description 13710 16 No System-versioned table schema modification failed because column '%.*ls' at ordinal %d in history table '%.*ls' has a different name than the column '%.*ls' at the same ordinal
Description 13724 16 No System-versioned table schema modification failed because adding computed column while system-versioning is ON is not supported.
Description 13742 16 No Table '%.*ls' contains records where 'GENERATED ALWAYS AS %ls' is not equal to %ls. 13743 16 No %ld is not a valid value for system versioning history retention period. 13744 1
Description 13760 16 No Accessing history table for memory optimized temporal table using the SERIALIZABLE isolation level is not supported while SYSTEM_VERSIONING is ON. 13761 16 No The hint '%.*ls'
Description 13771 16 No Setting finite retention period failed on system-versioned temporal table '%.*ls' because corresponding history table '%.*ls' has both clustered columnstore and non-clustered i
Description 13785 16 No System-versioned table schema modification failed because column '%.*ls' does not have the same sensitivity classification in tables '%.*ls' and '%.*ls'.
Description (%ls) in %ls. 13814 16 No Bulk load failed: Data file %ls does not have %ls encoding. 13815 16 No Consecutive wildcard characters present in path '%ls'. 13816 16 No File/directory path '%l
Description 13832 16 No Path '%ls' has URL suffix which is not allowed. 13833 16 No Multiple paths are only allowed from the same storage account and container. 13834 16 No Bulk load data conversion e
Description 13913 16 No Internal graph columns cannot be altered. 13914 16 No Cannot create a node or edge table as a temporary table.
Description 13932 16 No Cross-database edge constraints are not supported. 13933 16 No Edge constraint must reference node tables. 13934 16 No Could not drop node table '%.*ls' because it is reference
Description 13949 16 No The table name or alias '%.*s' was marked as FOR PATH but was not used in the recursive section of a SHORTEST_PATH clause.
Description 13966 16 No A recursive quantifier expression exceeds the limit of %d. Consider the '+' syntax instead. 13967 16 No Pseudocolumn '%.*ls' is not supported for use as a partitioning column o
Description 14002 16 No Could not find the 'Sync' subsystem with the task ID %ld. 14003 16 No You must supply a publication name. 14004 16 No %s must be in the current database.
Description
Description 14042 16 No Could not create Subscriber. 14043 16 No The parameter %s passed to stored procedure %s cannot be NULL. 14044 16 No Unable to clear subscriber status for the server. 14045 16 N
Description 14063 11 No The remote server does not exist or has not been designated as a valid Subscriber. 14064 10 No Found generation stuck at genstatus 4.
Description 14090 16 No Error evaluating article synchronization object after column drop. The filter clause for article '%s' must not reference the dropped column.
Description 14107 10 No The @max_distretention value must be larger than the @min_distretention value. 14108 10 No Removed %ld history records from %s. 14109 10 No The @security_mode parameter value m
Description 'pull'. 14129 16 No The @status parameter value must be NULL for 'automatic' sync_type when you add subscriptions to an immediate_sync publication. 14130 10 No WARNING: The database '%s' d
Description 14156 16 No The custom stored procedure calling the format for the %s command specified in the article definition does not match the %s format. 14157 10 Yes The subscription created by Sub
Description 14173 18 Yes Replication-%s: agent initialization failed. %s 14196 10 No The agent has never been run.
Description 14218 10 No hour 14219 10 No minute 14220 10 No second 14221 16 No This job has one or more notifications to operators other than '%s'.
Description 14241 10 No Job removed from %ld servers. 14242 16 No Only a system administrator can reassign ownership of a job. 14243 10 No Job '%s' started successfully.
Description 14268 16 No There are no jobs at this server that originated from server '%s'. 14269 16 No Job '%s' is already targeted at server '%s'.
Description 14290 16 No This job is currently targeted at the local server so cannot also be targeted at a remote server. 14291 16 No This job is currently targeted at a remote server so cannot also b
Description 14364 16 No The TSX server is not currently enlisted 14365 16 No Specify a valid schedule_uid. 14366 16 No Only members of sysadmin role can modify the owner of a schedule. 14367 16 No One
Description 14392 16 No Only owner of a job or members of role sysadmin or SQLAgentOperatorRole can purge history of the job. 14393 16 No Only owner of a job or members of role sysadmin or SQLAgentOpe
The restore job is failing.
Description operator before '%s' can be dropped. 14505 16 No Specify a null %s when supplying a performance condition. 14506 16 No Cannot set alerts on message ID %ld. 14507 16 No A performance condit
'Description 14523 16 No "%s" has not been granted permission to use proxy "%s". 14524 16 No Supply either %s or %s. 14525 16 No Only members of sysadmin role are allowed to update or delete jobs owned'
Description 14542 16 No It is invalid for any TSQL step of a multiserver job to have a non-null %s value. 14543 16 No Login '%s' owns one or more multiserver jobs.
Description 14565 10 No (goto step) 14566 10 No (idle) 14567 10 No (below normal) 14568 10 No (above normal) 14569 10 No (time critical) 14570 10 No (Job outcome) 14571 10 No No description available.
Description 14588 10 No ID.VersionID = 14589 10 No [not specified] 14590 16 No DTS Package '%s' already exists with a different ID in this category.
'Description 14628 16 No The format of the parameter @attachments is incorrect. The file names must be separated by a semicolon ";". 14629 16 No There is no configuration parameter named "%s", or the v'
Description 14648 10 No Minimum process lifetime in seconds 14649 16 No Unable to test profile. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. 14650 16 No Service Broker messag
Description 14668 16 No Deleting profile %s failed because there are some unsent emails associated with this profile, use force_delete option to force the deletion of the profile. 14670 16 No Cannot d
Description 14685 16 No Collection set: '%s' does not contain any collection items, so starting the collection set will have no effect.
Description 14702 10 No Disk Usage - Data Files 14703 10 No Disk Usage - Log Files 14704 10 No Collects top-level performance indicators for the computer and the Database Engine. Enables analysis of r
Description 14801 16 No Multiple REMOTE_DATA_ARCHIVE definition. 14802 16 No Cannot disable REMOTE_DATA_ARCHIVE because the database contains at least one table having REMOTE_DATA_ARCHIVE enabled. 148
Description 14820 20 No The stretch code generator output is corrupted. Stretch code generation and remote table provisioning will be re-tried.
Description 14835 16 No Cannot de-authorize database '%.*ls' because it is already disconnected from the remote database. 14836 16 No Cannot reconcile stretched indexes for database '%.*ls' because RE
Description 14852 16 No Cannot query table '%.*ls' because data reconciliation is in progress. This is part of the automatic recovery process for a remote data archive enabled table.
Description 14868 16 No Inbound migration is in progress or paused. Migration direction outbound cannot be set at this time. Please retry after inbound migration is complete. 14869 16 No Must be DB OW
Description 14886 16 No Cannot set the rpo duration for database '%.*ls' because REMOTE_DATA_ARCHIVE is not enabled on the database.
Description 14903 16 No Cannot rename column '%ls'. Columns on tables with REMOTE_DATA_ARCHIVE option enabled cannot be renamed.
Description Azure SQL Edge. 14919 16 No Change Feed is not supported for table '%ls' with REMOTE_DATA_ARCHIVE enabled.
Description 15001 16 No Object '%.*ls' does not exist or is not a valid object for this operation. 15002 16 No The procedure '%s' cannot be executed within a transaction. 15003 16 No Only members of t
Description 15024 16 No The group '%s' already exists in the current database. 15025 16 No The server principal '%s' already exists. 15026 16 No Logical device '%s' already exists.
Description 15058 16 No List of %s has too few names. 15059 16 No List of %s has too many names. 15060 16 No List of %s names contains name(s) which have '%s' non-alphabetic characters. 15061 16 No Th
Description 15096 16 No Could not find object '%ls' or you do not have required permission or the object is not valid for adding extended property.
Description 15114 16 No Password validation failed. The password for the user is too recent to change. 15115 16 No Password validation failed. The password cannot be used at this time. 15116 16 No Pas
Description object does not exist. 15136 16 No The database principal is set as the execution context of one or more procedures, functions, or event notifications and cannot be dropped. 15137 16 No An
Description 15176 16 No The only valid @parameter value is 'WITH_LOG'. 15177 16 No Usage: sp_dropmessage <msg number> [,<language> | 'ALL'] 15178 16 No Cannot drop a message with an ID less than 50,00
Description 15202 16 No There are no remote logins defined. 15203 16 No There are no remote logins for '%s'. 15204 16 No There are no remote logins for '%s' on remote server '%s'.
'Description 15228 16 No A member of the sysadmin role must set database ''%s'' to single user mode with sp_dboption before it can be renamed. 15229 16 No The argument specified for the "%.*ls" parameter'
Description 15250 16 No The database name component of the object qualifier must be the name of the current database. 15251 16 No Invalid '%s' specified. It must be %s.
Description 15271 16 No Invalid @with_log parameter value. Valid values are 'true' or 'false'. 15272 10 No The %s '%.*s' is not trusted to execute. 15273 10 No The decryption key is incorrect. 15274 1
Description 15292 10 No The row for user '%s' will be fixed by updating its login link to a login already in existence. 15293 10 No Barring a conflict, the row for user '%s' will be fixed by updating
Description 15312 16 No The file named '%s' is a primary file and cannot be removed. 15313 10 No The key is not encrypted using the specified decryptor. 15314 10 No Either no algorithm has been specif
Description 15331 11 No The user '%s' cannot take the action auto_fix due to duplicate SID. 15332 10 No The private key is already set for this file.
Description 15352 16 No The %S_MSG cannot be dropped because one or more entities are either signed or encrypted using it. 15353 16 No An entity of type %S_MSG cannot be owned by a role, a group, an a
Description 15370 16 Yes Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed.%.*ls 15371 16 Yes Failed to generate a user instanc
Description 15386 16 No Another batch in the session is changing security context, new batch is not allowed to start.
Review the following sections for actions you can take for each of the different causes mentioned above. 1. Verify that the Windows login still exists in the domain.
Description 15404 16 No Could not obtain information about Windows NT group/user '%ls', error code %#lx. 15405 11 No Cannot use the special principal '%s'.
Description 15428 16 No You cannot specify a provider or any properties for product '%ls'. 15429 16 No '%ls' is an invalid product name. 15431 16 No You must specify the @rolename parameter. 15432 16
Description 15457 10 No Configuration option '%ls' changed from %ld to %ld. Run the RECONFIGURE statement to install. 15458 10 No Database removed. 15459 10 No In the current database, the specified o
Description 15499 10 No The dependent aliases were mapped to the new database owner. 15500 10 No The dependent aliases were dropped. 15502 10 No Setting database owner to SA. 15503 10 No Giving owners
11. In Query 1, check the value of the value in . The value now reflects . SQL Output 12. In Query 2, check the value of the value in the table within the demonstration database. The value now reflect