Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 4 of 11.
If you encounter a similar scenario, address the underlying OS error. In this case work with your system administrator and hardware vendor to ensure that the disk device is online, functioning properl
Output If you encounter a similar scenario, address the underlying OS 112 error.
These are all various checks on log blocks when processing log records.
Description 9016 21 Yes An error occurred while processing the log for database '%.*ls'. The log block could not be decrypted.
Description 9033 16 Yes The transaction in database '%ls' has exceeded the max size of %I64u bytes. See 'http://aka.ms/sqldw_loglimit' for assistance. 9034 16 No PERSISTENT_LOG_BUFFER option is alread
Description 9053 17 No The transaction log for database '%.*ls' is full due to the database being on a higher service level objective (SLO) than one of its geo-secondary databases. Please update the S
'Msg 9100, Level 23, State 2, Line <LineNum> Possible index corruption detected. Run DBCC CHECKDB. When you execute a DBCC CHECKDB or DBCC CHECKTABLE command, SQL Server performs "data purity" validati'
Description 9118 16 No %.*ls was specified as part of the CREATE/UPDATE STATISTICS syntax without %.*ls. They must be used together. 9119 16 No The table name '%.*ls' exceeds the maximum length of 128
Description dropped or modified. 9137 16 No The statement failed because the necessary statistics could not be automatically created for '%.*ls' due to a change in the table schema since the snapshot
Description 9214 16 No The query notification delivery failed to decode the error message from the Service Broker. 9215 16 No Query notification delivery failed to encode message.
Description 9230 16 No Option '%ls' was specified multiple times in the notification options identifier. 9231 16 No An equal (=) character was expected after the option name. Found '%.*ls' instead. 92
Description 9300 16 No %sIn this version of the server, the 'fn:id()' function only accepts an argument of type 'IDREF *'. 9301 16 No %sIn this version of the server, 'cast as <type>%s' is not availab
Description 9320 16 No %sThe result of applying the 'parent' axis on the document node is statically 'empty'. 9321 16 No %sThe result of applying 'parent::%ls' is statically 'empty'. 9322 16 No %sTwo
Description 9341 16 No %sSyntax error near '%ls', expected a step expression. 9342 16 No %sAn XML instance is only supported as the direct source of an insert using sql:column/sql:variable. 9343 16 No
Description 9448 16 No XML parsing: line %d, character %d, well formed check: undeclared entity 9449 16 No XML parsing: line %d, character %d, well formed check: parsed entity 9450 16 No XML parsing:
Description 9500 16 No The data type '%.*ls' used in the VALUE method is invalid. 9501 16 No XQuery: Unable to resolve sql:variable('%.*ls'). The variable must be declared as a scalar TSQL variable. 9
Description characters. 9519 16 No XQuery: The name supplied to sql:variable('%.*ls') is not a valid SQL variable name. Variable names must start with the '@' symbol followed by at least one character
Description 9531 16 No In the XML content that is supplied for the column set column '%.*ls', the '%.*ls' attribute value on the element '%.*ls' is not valid.
Description 9610 16 No The service '%.*ls' in the FROM SERVICE clause must match the service '%.*ls' referenced by %s = '%.*ls'. 9611 16 No Cannot find the specified user '%.*ls'.
Description 9629 16 No The decrypted signature size is wrong. 9630 16 No The signature did not verify the internal hash. 9631 16 No The salt size is unacceptable for this key object.
Description 9648 20 No The queue '%.*ls' has been enabled for activation, but the MAX_QUEUE_READERS is zero. No procedures will be activated. Consider increasing the number of MAX_QUEUE_READERS. 9649
Description 9668 10 No Service Queues analyzed: %d. 9669 10 No Conversation Endpoints analyzed: %d. 9670 10 No Remote Service Bindings analyzed: %d.
Description 9690 10 Yes The %S_MSG endpoint is now listening for connections. 9691 10 No The %S_MSG endpoint has stopped listening for connections.
Description 9708 16 No The messages in the queue with ID %d are referencing the invalid conversation group '%ls'.
Description 9726 16 No The remote service binding with ID %d has been dropped.
Description 9740 16 No Cannot start the Service Broker message dispatcher. This error is a symptom of another problem. Check the SQL Server error log and the operating system error log for additional
Description 9759 10 No An error occurred while sending data: '%.*ls'. 9760 10 No The connection has been idle for over %d seconds. 9761 16 Yes The Broker Configuration conversation on dialog handle '%
'Description 9775 16 No Cannot create a new Service Broker in read-only database "%.*ls". 9776 16 No Cannot enable the Service Broker in database "%.*ls" because the Service Broker GUID in the database'
Description Server instance. 9793 10 No The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied. 9794 10 No The
Description 9813 16 No The timezone provided to builtin function %.*ls would cause the datetimeoffset to overflow the range of valid date range in either UTC or local time. 9814 16 No The date provide
'Description 9832 16 No Index and length must refer to a location within the string. Parameter name: %ls. 9833 16 No Invalid data for %ls-encoded characters 9834 16 No Invalid bucket width value passe'
Description 9903 10 No The full-text catalog health monitor reported a failure for full-text catalog '%ls' (%d) in database '%ls' (%d). Reason code: %d. Error: %ls. The system will restart any in-prog
Description x%x. Repeat the operation that triggered the resume, or drop and re- create the index. 9915 10 No Reinitialized full-text %ls population for table '%ls' (table ID '%d', database ID '%d') a
Description 9930 10 No Null document type provided. Row will not be full-text indexed. 9931 10 No Document type exceeds the maximum permitted length. Row will not be full-text indexed. 9932 10 No Docu
Description 9945 10 No Error: All Full-text populations in progress, for catalog '%ls' ('%d') in database '%ls' ('%d') were terminated due to error. x%x. 9946 10 No Warning: Failed to mount full-text
Description full-text search functionality will not be available. Please make sure the account exists and is enabled. 9957 16 No Full-text operation failed due to full-text catalog %ls is corrupted. U
Description 9973 10 No Informational: Full-text %ls population paused for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'). Number of documents processed: %d.
Description 9989 16 No Cannot use full-text search in this instance. 9990 16 No Failed to retrieve full-text batch size configuration. A batch size of %d will be used instead.
Description 527 16 No Implicit conversion between XML types constrained by different XML schema collections is not allowed. Use the CONVERT function to run this query.
Description 10000 16 No Unknown provider error. 10001 16 No The provider reported an unexpected catastrophic failure. 10002 16 No The provider did not implement the functionality.
Description 10034 16 No The specified table or view does not exist or contains errors. 10035 16 No No value was given for one or more of the required parameters. 10042 16 No Cannot set any properties
Description 10085 16 No RestartPosition on the table was canceled during notification. 10086 16 No The table was built over a live data stream and the position cannot be restarted.
'Description 10110 16 No Cannot create %S_MSG on view "%.*ls" because it contains an OUTER APPLY. Consider not indexing the view, or removing OUTER APPLY. 10111 16 No Cannot create %S_MSG on view "%.*l'
'Description alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG. 10126 16 No Cannot create %S_MSG on view "%.*ls" because it uses aggregate "%.*'
Description 10139 16 No Cannot create %S_MSG on view '%.*ls' because the view uses an implicit conversion from string to datetime or smalldatetime. Use an explicit CONVERT with a deterministic style v
'Description 10227 16 No Field "%.*ls" of type "%.*ls.%.*ls" cannot be updated because the field is "%.*ls". 10240 16 No Could not find UdtExtensions.dll. Please check your installation. 10300 16 No As'
Description 10313 16 No An error occurred while using the .NET Framework during %S_MSG. The server may be running out of resources. Try running the query again.
Description 10330 16 No ALTER ASSEMBLY failed because serialization layout of type '%s' would change as a result of a change in type '%s' in the updated assembly.
Description UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly. 10344 16 No Internal table access error: failed to access the Trusted Assemblies intern
Description 10510 16 No Cannot create plan guide '%.*ls' because there is already a plan guide with that name in the database. Use a unique name. 10511 16 No Cannot create plan guide '%.*ls' because @
Description 10523 16 No Cannot generate query template because @querytext does not contain a valid single query. 10524 16 No Cannot parameterize @querytext.
Description handle. For a list of cached plan handles, query the sys.dm_exec_query_stats dynamic management view. 10536 16 No Cannot create plan guide '%.*ls' because the batch or module corresponding
Description 10609 16 No Filtered %S_MSG '%.*ls' cannot be created on table '%.*ls' because the column '%.*ls' in the filter expression is a computed column.
Description 10629 16 No The data type specified for column '%.*ls' in table '%.*ls' cannot be used as a column in the distribution key of an index. 10633 16 No Invalid online index creation operation
Description 10646 16 No Index '%.*ls' on view '%.*ls' that has SNAPSHOT_MATERIALIZATION cannot be dropped using the DROP_EXISTING option. 10647 16 No Index '%.*ls' on '%.*ls' that has SNAPSHOT_MATERIA
Description 10663 10 Yes The refresh operation for snapshot view '%.*ls' failed because refresh operation for all snapshot views was already in progress.
Description 10679 16 No Online columnstore index is not supported with ORDER clause. 10680 16 No ALTER INDEX ALL '%S_MSG' failed. There is no pending resumable index operation on '%.*ls'. 10681 16 No
Description 10713 15 No A MERGE statement must be terminated by a semi-colon (;). 10714 15 No An action of type '%S_MSG' cannot appear more than once in a '%S_MSG' clause of a MERGE statement. 10715 1
Description 10729 15 No A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in a SELECT statement that is not the immediate source of rows for an INSERT statement. 10730 15 No A nested
Description 10746 15 No The FORCESCAN hint is specified simultaneously with the FORCESEEK hint. Remove one of the hints and resubmit the query. 10747 15 No The parameterized FORCESEEK hint cannot be s
Description grouping columns and re-run the query. 10765 15 No DISTRIBUTED_AGG and CENTRAL_AGG hints cannot be used with a CUBE or ROLLUP clause. Modify the query and re-run it. 10766 15 No CENTRAL_AG
Description 10780 16 No There is no primary key in the referenced table '%.*ls' that matches the referencing column list in the foreign key '%.*ls'.
Description 10798 16 No This is not a valid data compression setting for this object. It can only be used with columnstore indexes. Please choose NONE, PAGE, or ROW compression.
Description %u. 10909 16 No The resource pool cannot be created. The maximum number of resource pools cannot exceed current limit of %u including predefined resource pools. 10910 16 No The operation c
Description 10924 16 No The pool affinity range is invalid. The lower bound %d must be less than the upper bound %d.
Description 10938 16 No Contained Availability Group connections do not support Resource Governor DDL. Please retry using the instance connection.
Description 11000 16 No Unknown status code for this column. 11001 16 No Non-NULL value successfully returned. 11002 16 No Deferred accessor validation occurred. Invalid binding for this column. 11003
Description 11037 16 No The row has a pending delete or the deletion had been transmitted to the data source. 11038 16 No The row is a pending insert row. 11039 16 No DBPROP_CHANGEINSERTEDROWS was VAR
Description 11201 16 No This message could not be delivered because the FROM service name is missing. The message origin is: '%ls'. 11202 16 No This message has been dropped because the FROM service n
Description 11216 16 No This message could not be delivered because there is already another task processing this message. 11217 16 No This message could not be delivered because it is out of sequence
Description 11230 16 No This message could not be delivered because the message could not be decrypted and validated. 11231 16 No This message could not be delivered because the conversation endpoint
Description elements found: %d. 11246 16 No A corrupted message has been received. The private variable data element (%d) has been duplicated in this message.
Description 11258 16 No A corrupted message has been received. The MIC size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID '%.*ls', Ini
Description 11268 16 No A corrupted message has been received. The salt size is %d, however it must be %d bytes. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message s
Description 11279 16 No A corrupted message has been received. The message type must not be set in this message. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message s
Description 11297 16 No A corrupted message has been received. The private variable data segment offset is incorrect. 11298 16 No A corrupted message has been received. The public variable data segmen
Description 11322 16 No Controlling explicit transactions and creating savepoints (BEGIN/SAVE/COMMIT/ROLLBACK TRANSACTION) is not supported inside ATOMIC blocks.
Description 11407 16 No Vardecimal storage format can not be enabled for '%.*ls'. Only Enterprise edition of SQL Server supports vardecimal. 11408 16 No Cannot modify the column '%.*ls' in the table '
Description using the WAIT_AT_LOW_PRIORITY options with MAX_DURATION = %d and ABORT_AFTER_WAIT = BLOCKERS. Blocking user sessions will be killed after the max duration of waiting time. 11423 14 No Use
Description 11436 16 No Cannot alter table '%.*ls' because non-nullable column '%.*ls' cannot be declared as hidden without either a DEFAULT constraint, the GENERATED ALWAYS attribute, or the IDENTITY
Description 11502 16 No The type for parameter '%.*ls' cannot be deduced in this context. 11503 16 No The parameter type cannot be deduced because a single expression contains two untyped parameters,
Description 11517 16 No The metadata could not be determined because statement '%.*ls' invokes a CLR trigger. 11518 16 No The metadata could not be determined because statement '%.*ls' in procedure '%
Description 11532 16 No The object id '%d' passed to sys.dm_exec_describe_first_result_set_for_object was invalid. 11533 16 No Type '%.*ls' is not a valid object name for result set definition. 11534
Description 11549 16 No Using stored procedures is not supported. Modify the input parameter and re-run sp_showmemo_xml. 11550 16 No The metadata could not be determined because remote metadata discov
Description 11565 16 No The %.*ls JSON string could not be parsed. Please check the formatting of the JSON. 11566 16 No Column %i ('%.*ls') has type '%.*ls', which is not currently supported by native
Description 11613 15 No Numbered stored procedures are not supported. 11614 15 No %ls is not supported. 11617 16 No An unknown error has occurred trying to load '%hs'.
Description 11707 10 No The cache size for sequence object '%.*ls' has been set to NO CACHE. 11708 16 No An invalid value was specified for argument '%.*ls' for the given data type. 11709 15 No The 'R
Description 11727 16 No NEXT VALUE FOR functions for a given sequence object must have exactly the same OVER clause definition.
Description 11743 16 No Timeout occurred while waiting for METADATA_SEQUENCE_GENERATOR latch: waittime %d seconds. 11744 15 No NEXT VALUE FOR must have ORDER BY.
Description ALWAYS attribute, or the IDENTITY attribute. 11904 16 No Cannot create table '%.*ls' because at least one column must be declared as non-hidden.
Description 12012 16 No The value of parameter '%.*ls' of CREATE %S_MSG must be greater than %d. 12013 16 No The value of parameter '%.*ls' of CREATE %S_MSG must be greater than the value of parameter
Description 12104 15 No ALTER DATABASE CURRENT failed because '%.*ls' is a system database. System databases cannot be altered by using the CURRENT keyword.
Description 12118 16 No The ADD FILE operation failed because the requested file ID '%d' is invalid. 12119 16 No The ADD FILE operation failed because there is an ongoing ADD FILE operation. 12120 16
Description 12133 16 No Optimized Locking cannot be enabled for this database because Accelerated Database Recovery is not enabled. Enable Accelerated Database Recovery and try again. 12134 16 No Opti
Description 12302 15 No Updating columns that are part of the PRIMARY KEY constraint is not supported with %S_MSG. 12303 15 No The 'number' clause is not supported with %S_MSG.
Description 12323 15 No Distributed Queries and Multiple Active Result Sets (MARS) are not supported with %S_MSG. 12324 15 No Distributed transactions (DTC) are not supported with %S_MSG. 12325 15 No
Description 12342 15 No The EXECUTE statement in %S_MSG only supports executing natively compiled modules. 12343 16 No TRIGGER_NESTLEVEL only supports zero or one argument in %S_MSG. 12344 16 No Only
Description 12359 15 No Ledger tables are not supported with %S_MSG. 12401 15 No The %S_MSG option '%S_MSG' was specified more than once. Each option can be specified only once.
Description 12419 16 No The command failed because Query Store is disabled on the server or database you are using. Contact customer support to get this addressed.
Description 12437 17 No Query Store global Resource Group cannot be determined. 12438 16 No Cannot perform action because Query Store cannot be enabled on system database %.*ls. 12439 10 Yes Setting d