Database Engine Errors
SQL Server diagnostic error codes organized by severity level and category. Each error includes error number, severity classification, and description. — Page 8 of 11.
Description 22639 16 No Aborting Fabric Link Commit Notification task for this database timed out. Retry this operation later. 22640 16 No The table could not be removed from the Change Feed. Please t
Description 22708 16 No The specified database scoped credential name does not match the landing zone URL path 22709 16 No Parameter '%s' cannot be null or empty. Specify a value for the named paramet
Description 22725 16 No Enabling Change Feed for a ledger history table '%ls' is not allowed. 22726 16 No Could not allocate memory for Change Feed operation.
'Description Change Feed on the database. 22744 16 No Cannot disable primary key index "%.*ls" on table "%.*ls" because the table has change feed enabled on it. 22745 16 No Cannot alter the table ''%.*l'
Description 22761 16 No Failed to cleanup previous change feed setup. Please try the operation again. If the problem persists contact Microsoft Azure Customer Support. 22762 16 No Cannot enable '%S_MS
Description dynamic management view. 22802 16 No Starting the Change Data Capture Cleanup Agent job using low watermark %s. 22803 16 No Change Data Capture has scanned the log from LSN{%s} to LSN{%s},
Description 22816 16 No The qualified table name '%s' is too long to be enabled for peer-to-peer conflict detection. 22817 10 No %s has %s. 22818 10 No A delete-delete conflict was detected and resolv
Description '%s'. The error returned was %d: '%s'. Use the action and error to determine the cause of the failure and resubmit the request.
Description 22841 16 No Could not upgrade the metadata for database '%s' that is enabled for Change Data Capture. The failure occurred when executing the action '%s'. The error returned was %d: '%s'.
Description 22856 10 No Warning: The @allow_partition_switch parameter is set to 0. ALTER TABLE ... SWITCH PARTITION statement will be disallowed on this partitioned table. Refer to books online for m
Description 22869 10 No Internal Change Tracking table name : %s 22870 10 No Deleted %I64u rows from %s 22871 16 No Change Data Capture is not supported on Free, Basic or Standard tier Single Database
Description 22895 16 No Could not drop cdc user. CDC user is required for proper working of CDC. 22896 10 No sp_cdc_disable_db caught an exception in try block when executing command : '%s'.
Description same database. When Change Data Capture and transactional replication are both enabled on a database, use the logreader agent to extract the log changes. 22912 16 No sp_repldone failed 229
Description 22926 16 No Could not create a capture instance because the capture instance name '%s' already exists in the current database. Specify an explicit unique name for the parameter @capture_in
Description 22943 16 No Columns used to uniquely identify a row for net change tracking must be included in the list of captured columns.
Description 22954 16 No Could not cleanup change tables for capture instance '%s' using low end point %s. Refer to previous errors in the current session to identify the cause and correct any associat
Description information, see 'Delimited Identifiers' in Books Online. 22966 16 No Could not create table dbo.systranschemas in database '%s'. Refer to previous errors in the current session to identif
Description previous errors in the current session to identify the cause and correct any associated problems.
Description in the Enterprise, Developer, Enterprise Evaluation, and Standard editions. 22989 16 No Could not enable Change Data Capture for database '%s'.
Description 23003 17 No The WinFS share permissions have become corrupted {Error: %ld}. Please try setting the share permissions again. 23100 16 No Invalid input parameter(s).
Description 23201 16 No Share '%ls' does not exist in Catalog. 23202 16 No Could not delete Share '%ls' in Catalog. 23203 16 No Store item not found in Catalog.
Description 900 16 No Failed to start buffer pool extension because the file configuration has changed and is incompatible with the existing one. 902 16 No To change the %ls, the database must be in s
Description https://go.microsoft.com/fwlink/?linkid=2323205 . 42102 10 No Reason: Unable to set Deny Public Network Access to Yes because there is no private endpoint to access the server.
Description Vault in the region '%ls' as server '%ls'. For more information, see https://go.microsoft.com/fwlink/?linkid=2323436 . 45385 16 No Unexpected Key Vault region found in the response for Key
Description information, see https://go.microsoft.com/fwlink/?linkid=2323734 .
Description 23530 16 No Operation can not be called inside a un-committable transaction 23536 16 No Win32 file handle is open for item 23573 16 No Cannot change ContainerId when replacing item. 23579
Description 23638 16 No Change Streams encountered an Avro Exception: '%ls'. 23639 16 No Change Streams encountered a serialization exception: '%s'. 23640 16 No Change Streams serializer not initialzi
Description 23657 16 No The number of tables enabled for a Change Streams table group cannot exceed %d. Current number of tables enabled: %d. 23658 16 No Change Streams encountered a SQL Exception. Er
Description 23999 16 No Unspecified error(s) occurred. 24501 16 No Internal error when retrieving lock information. Please try the operation again. If the problem persists contact Microsoft Azure Cust
Description Microsoft Azure Customer Support. 24520 16 No The metadata log for the database '%.*ls' is corrupted at Block '%I64d' RecordId '%I64d'. 24521 16 No The metadata log Block '%I64d' for the d
Description 24543 16 No Cannot begin a transaction with the given isolation level. Please specify the snapshot isolation level when explicitly beginning the transaction. 24544 16 No The current isolat
Description 24562 16 No Input not provided. Could not create vdw service principal. Please provide mandatory parameters to create service principal. 24563 16 No Invalid input.
Description 24585 16 No The specified ALTER TABLE statement is not supported in this edition of SQL Server. 24586 16 No Distributed transactions are not supported in this edition of SQL Server. 24590
Description 24609 17 No x%X occurred while trying to access data exceeding the permitted limit. If the error persists, please contact support. 24610 17 No Unsupported data movement functionality was u
Description ordered column count %d. 24716 16 No sp_get_managed_delta_table_log_files_metadata is unable to generate the output xml. 24717 16 No sp_check_file_cleanup_eligibility is unable to generate
Description 24733 16 No An unexpected error occurred during execution. 24734 17 No There was an error during stored procedure execution. 24735 16 No Only nullable columns can be added to an existing t
Description 24756 16 No The query failed because handling end of file happened before whole IO buffer was populated: %ls.
Description 24774 18 No Internal error occurred during DW table metrics retrieval. 24775 18 No Internal system error (%ls) when attempting to open or create remotely stored delta log file.
Description 24792 18 No Table '%ls' with classification '%ls' is not eligible for maintenance operation. 24793 16 No Refresh is only available for external tables.
Description LIVE mode. 24812 18 No Setting SOURCE_DATABASE failed. 24813 16 No Specifying an explicit value for the identity column '%.*ls' in table '%.*ls' is not supported. 25002 16 No The specified
'Description 25016 10 No Prepare Dynamic Snapshot 25017 16 No Failed to execute the command "%s" through xp_cmdshell. Detailed error information is returned in a result set. 25018 16 No Precomputed par'
Description 25032 10 No Sync replication agent jobs and their enabled states. 25033 16 No The distribution database is part of an availability group without a listener. Add a listener to the availabil
Description packages has been reached. 25606 17 No The Extended Event engine could not be initialized. Check the SQL Server error log and the operating system error log for information about possible
'Description 25642 16 No Mandatory customizable attributes are missing for %S_MSG, "%.*ls". 25643 16 No The %S_MSG, "%.*ls", can not be added to an event session that specifies no event loss. 25644 16 '
'Description allowed. 25702 16 No The event session option, "%.*ls", is set more than once. Remove the duplicate session option and re-issue the statement. 25703 16 No The event session option, "%.*ls"'
'Description 25721 16 No The metadata file name "%s" is invalid. Verify that the file exists and that the SQL Server service account has access to it. 25722 16 No The offset %I64d is invalid for log fi'
'Description 25736 16 No A damaged buffer was found in file "%s" at offset %I64d, no further events will be read from the file. 25737 16 No Database scoped extended event sessions are not available in '
Description 25753 10 No XE session '%s' started. 25754 10 No XE session '%s' stopping. 25755 16 No Could not create live session target because live session targets are disabled.
Description 26010 10 Yes The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: %#x. Check certificates to make sure they are valid. 26011 1
imply that you only have to take corrective action on the mirror server instance. However, corrective actions might be required on both partners. Make sure that the mirror database is ready for mirror
Description 26029 16 Yes Server named pipe provider failed to listen on [ %s ]. Error: %#x 26032 10 Yes Server VIA provider is ready for clients to connect to [ %hs:%d ].
Description 26049 16 Yes Server local connection provider failed to listen on [ %s ]. Error: %#x 26050 17 Yes Server local connection provider has stopped listening on [ %s ] due to a failure. Error:
Description problem with the network configuration of the computer. Error: %#x. 26062 16 Yes Invalid parameter detected while initializing TCP listening port. Error: %#x, state: %d. Contact Technical
Description 26072 10 Yes Found multiple dependent virtual network names for the Windows Failover Cluster Resource '%ls'. SQL Server will only listen on the first virtual network name resource: '%ls'.
Description 27002 16 No A null or invalid SqlCommand object was supplied to Fuzzy Lookup Table Maintenance by SQLCLR. Reset the connection. 27003 16 No Bad token encountered during tokenization. 27004
Description 27024 16 No Cannot write at negative index position. Could not update Error Tolerant Index. The index is probably corrupt. 27025 16 No Argument is not a valid hex string. Could not initial
Description 27045 16 No Cannot write to null output buffer. Could not update Error Tolerant Index. The index is probably corrupt. 27046 16 No Output buffer provided is too small. Could not update Erro
Description is corrupt. 27100 16 No The input parameter, '%ls', cannot be null. Provide a valid value for this parameter. 27101 16 No The value specified for the input parameter, '%ls', is not valid.
Description 27118 16 No Failed to deploy the project. Try again later. 27119 16 No Failed to encrypt the project named '%ls'. The symmetric key may have been deleted.
Description 27136 16 No The required components for the 32-bit edition of Integration Services cannot be found. Run SQL Server Setup to add the required components.
Description 27152 10 No The restore operation for project '%ls' to version '%I64d' has completed. 27153 16 No Default permissions for the operation cannot be granted to the user.
Description 27167 16 No Failed to change the encryption algorithm to '%ls'. An error occurred while encrypting the environment variables with the '%ls' algorithm.
Description 27186 16 No One or more environment variables could not be found in the referenced environment. 27187 16 No The project does not exist or you have not been granted the appropriate permissi
Description 27204 16 No Failed to create environment reference. This project already has an reference to the specified environment.
Description cannot be found. Run SQL Server Setup to install the required components. 27223 16 No Cannot move the project to folder '%ls' due to insufficient permissions.
Description 27242 16 No Cannot find the cluster execution job instance '%ls' because it does not exist or you do not have sufficient permissions. 27243 16 No Cannot find the cluster worker agent '%ls'
Description 27406 10 No The database registration was not found during an external governance operation.
Description 27426 16 Yes External governance synchronization task failed to acquire lock while trying to synchronize attributes. 27427 16 Yes External governance synchronization task failed to initial
Description 27519 16 No A query header update buffer length HTTP error occurred. 27520 16 No A read data HTTP error occurred. 27521 16 No A get response out of memory (create temp buffer) HTTP error o
Description Classification feature. Remove any existing labels from the database prior to assigning Microsoft Purview Information Protection labels. For more information, see https://aka.ms/SQLPurview
Description 28000 16 No The decrypted session key has an unexpected size. 28001 16 No A corrupted message has been received. It contains invalid flags. This occurred in the message with Conversation I
Description 28016 16 No The message has been dropped because the service broker in the target database is unavailable: '%S_MSG'.
Description 28033 10 No A new connection was established with the same peer. This connection lost the arbitration and it will be closed. All traffic will be redirected to the newly opened connection.
Description 28048 10 Yes %S_MSG login attempt by user '%.*ls' failed with error: '%.*ls'. %.*ls 28049 16 No A corrupted message has been received. The proxy connect message header is invalid. 28050 10
Description 28062 16 No A corrupted message has been received. The signed dialog message header is invalid. 28063 16 No A corrupted message has been received.
Description SET ERROR_BROKER to error all conversations in this database. Use ALTER DATABASE ... SET NEW_BROKER to delete all conversations in this database.
Description compatibility with implicitly connected user schemas. 28090 16 No An error occurred while deleting sent messages from the transmission queue, Error: %i, State: %i.
Description 30007 16 No Parameters of dm_fts_index_keywords, dm_fts_index_keywords_by_document, dm_fts_index_keywords_by_property, and dm_fts_index_keywords_position_by_document cannot be null. 30008
Description search property lists on the current database, use the sys.registered_search_property_lists catalog view.
Description 30047 16 No The user does not have permission to %.*ls stoplist '%.*ls'. 30048 10 No Informational: Ignoring duplicate thesaurus rule '%ls' while loading thesaurus file for LCID %d.
Description 30060 16 No The import population for database %ls (id: %d), catalog %ls (id: %d) is being cancelled because of a fatal error ('%ls').
Description 30082 16 No Full-text predicates cannot appear in an aggregate expression. Place the aggregate expression in a subquery.
Description until this issue is resolved. Try stopping SQL Server and any filter daemon host processes and then restarting the instance of SQL Server.
Description 31001 16 No The session '%s' already exists. Use a different session name. 31002 16 No This operation can be performed only by the owner of the session.
Description 31016 16 No Could not cleanup hypothetical indexes and statistics when cancelling DTA tuning for auto indexing. 31017 16 No DTA tuning for auto indexing is only supported on Azure DB. 3101
Description 31207 16 No Invalid value for Full-Text index version is specified. Valid values are 1 or 2. 31208 16 No A fulltext fragment table is missing. 31601 16 No The size of the provided %ls is %
Description 31620 16 No The %ls is not a json object datatype. 31621 16 No One of the %ls values could not be parsed. 31622 16 No An unexpected error occurred while validating that the connection to t
Description 31641 16 No The charset value of the response's Content-Type header is not supported. 31642 16 No The value of one of the key-value pairs in the %ls is empty. 31643 16 No '%ls' is disabled
Description 31721 17 No Failed to run Fabric function with error %d %ls. 31723 17 No Failed to fetch service endpoint. 31724 16 No Type %ls is not supported by Fabric functions.
Description 32002 10 No Log shipping copy job for %s:%s. 32003 10 No Log shipping restore log job for %s:%s. 32004 10 No Log shipping backup log job step. 32005 10 No Log shipping copy job step. 32006
Description 32023 16 No An entry for primary server %s, primary database %s does not exist on this secondary. Register the primary first. 32024 16 No An entry for primary server %s, primary database %
Description 32041 16 No The database mirroring monitor base tables have not been created. Please run sys.sp_dbmmonitorupdate to create them. 32042 16 No The alert for 'unsent log' has been raised. The
Check for the latest build . Update SQL Server versions to protect from running into issues like KB3213703 . For more information, see Create Availability Group Fails With 'Failed to join the databas
Description 180 15 No There are too many parameters in this %ls statement. The maximum number is %d. 181 15 No Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.
Description 33002 16 No Access to %ls %ls is blocked because the signature is not valid. 33003 16 No DDL statement is not allowed. 33004 16 No The password of login '%.*ls' is invalid. A new password
Description 33020 16 No A HASHED password cannot be set for a login that has CHECK_POLICY turned on. 33021 16 Yes Failed to generate a user instance of SQL Server. Only local user accounts, interactiv
Description 33041 16 Yes Cannot create login token for existing authenticators. If dbo is a windows user make sure that its windows account information is accessible to SQL Server. 33042 16 No Cannot
Description events may be lost. 33060 16 No The format of supplied parameter sid is invalid. The sid might be incorrect or the sid might describe the wrong type of user. 33061 16 No The specified RETE
Description 33074 16 No Cannot %S_MSG a %S_MSG %S_MSG from a user database. This operation must be performed in the master database. 33075 16 No Granular auditing is not available in this edition of S
Description 33090 10 No Attempting to load library '%.*ls' into memory. This is an informational message only. No user action is required.