Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Practice Test
Tip of the Day : SQL Server Tutorial - INSERT Statement 101
Error Messages
Home > Tips & Tricks > Error Messages 11001 to 11500
SQL Server Error Messages - Errors 11001 to 11500

A message number uniquely identifies each error message and the error message text describes the problem.  The error message text often includes placeholders for information (such as object names) to be inserted in the error message when it is displayed.  Unfortunately, the error message text does not tell you how to solve or work around the problem.  In this series of Error Messages list, we will try to provide you with ways on how to overcome or work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as "Invalid object name".  Others are harder to fix or work around, especially by those who are new to SQL Server.  It is the intent of this page and succeeding pages (to come) to assist you in addressing or working around SQL Server error messages.

Error Severity Description
11001 16 Non-NULL value successfully returned.
11002 16 Deferred accessor validation occurred. Invalid binding for this column.
11003 16 Could not convert the data value due to reasons other than sign mismatch or overflow.
11004 16 Successfully returned a NULL value.
11005 16 Successfully returned a truncated value.
11006 16 Could not convert the data type because of a sign mismatch.
11007 16 Conversion failed because the data value overflowed the data type used by the provider.
11008 16 The provider cannot allocate memory or open another storage object on this column.
11009 16 The provider cannot determine the value for this column.
11010 16 The user did not have permission to write to the column.
11011 16 The data value violated the integrity constraints for the column.
11012 16 The data value violated the schema for the column.
11013 16 The column had a bad status.
11014 16 The column used the default value.
11015 16 The column was skipped when setting data.
11031 16 The row was successfully deleted.
11032 16 The table was in immediate-update mode, and deleting a single row caused more than one row to be deleted in the data source.
11033 16 The row was released even though it had a pending change.
11034 16 Deletion of the row was canceled during notification.
11036 16 The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
11037 16 The row has a pending delete or the deletion had been transmitted to the data source.
11038 16 The row is a pending insert row.
11039 16 DBPROP_CHANGEINSERTEDROWS was VARIANT_FALSE and the insertion for the row has been transmitted to the data source.
11040 16 Deleting the row violated the integrity constraints for the column or table.
11041 16 The row handle was invalid or was a row handle to which the current thread does not have access rights.
11042 16 Deleting the row would exceed the limit for pending changes specified by the rowset property DBPROP_MAXPENDINGROWS.
11043 16 The row has a storage object open.
11044 16 The provider ran out of memory and could not fetch the row.
11045 16 User did not have sufficient permission to delete the row.
11046 16 The table was in immediate-update mode and the row was not deleted due to reaching a limit on the server, such as query execution timing out.
11047 16 Updating did not meet the schema requirements.
11048 16 There was a recoverable, provider-specific error, such as an RPC failure.
11100 16 The provider indicates that conflicts occurred with other properties or requirements.
11101 16 Could not obtain an interface required for text, ntext, or image access.
11102 16 The provider could not support a required row lookup interface.
11103 16 The provider could not support an interface required for the UPDATE/DELETE/INSERT statements.
11104 16 The provider could not support insertion on this table.
11105 16 The provider could not support updates on this table.
11106 16 The provider could not support deletion on this table.
11107 16 The provider could not support a row lookup position.
11108 16 The provider could not support a required property.
11109 16 The provider does not support an index scan on this data source.
11201 16 This message could not be delivered because the FROM service name is missing. The message origin is: '%ls'.
11202 16 This message has been dropped because the FROM service name exceeds the maximum size of %d bytes. Service name: "%.*ls". Message origin: "%ls".
11203 16 This message has been dropped because the FROM broker instance is missing. The message origin is '%ls'.
11204 16 This message has been dropped because the FROM broker instance exceeds the maximum size of %d bytes. Broker instance: "%.*ls". Message origin: "%ls".
11205 16 This message has been dropped because the TO service name is missing. The message origin is "%ls".
11206 16 This message has been dropped because the TO service name exceeds the maximum size of %d bytes. Service name: "%.*ls". Message origin: "%ls".
11207 16 This message has been dropped because the service contract name is missing. The message origin is "%ls".
11208 16 This message has been dropped because the service contract name exceeds the maximum size of %d bytes. Contract name "%.*ls". Message origin: "%ls".
11209 16 This message could not be delivered because the conversation ID could not be associated with an active conversation. The message origin is: '%ls'.
11210 16 This message has been dropped because the TO service could not be found. Service name: "%.*ls". Message origin: "%ls".
11211 16 This message has been dropped because the user does not have permission to access the target database. Database ID: %d. Message origin: "%ls".
11212 16 This message could not be delivered because the conversation endpoint has already been closed.
11213 16 This message could not be delivered because this is not the first message in the conversation.
11214 16 This message could not be delivered because the '%.*ls' contract could not be found or the service does not accept conversations for the contract.
11215 16 This message could not be delivered because the user with ID %i in database ID %i does not have permission to send to the service. Service name: '%.*ls'.
11216 16 This message could not be delivered because there is already another task processing this message.
11217 16 This message could not be delivered because it is out of sequence with respect to the conversation. Conversation receive sequence number: %I64d, Message sequence number: %I64d.
11218 16 This message could not be delivered because it is a duplicate.
11219 16 This message could not be delivered because the destination queue has been disabled. Queue ID: %d.
11220 16 This message could not be delivered because the TO broker instance is missing.
11221 16 This message could not be delivered because there is an inconsistency in the message header.
11222 16 This message could not be delivered because the TO service name in the message does not match the name in the conversation endpoint. Message TO Service Name: '%.*ls'. Conversation Endpoint TO Service Name: '%.*ls'.
11223 16 This message could not be delivered because the service contract name in the message does not match the name in the conversation endpoint. Message service contract name: '%.*ls'. Conversation endpoint service contract name: '%.*ls'.
11224 16 This message could not be delivered because another instance of this service program has already started conversing with this endpoint.
11225 16 This message could not be delivered because the message type name could not be found. Message type name: '%.*ls'.
11226 16 This message could not be delivered because the message type is not part of the service contract. Message type name: '%.*ls'. Service contract name: '%.*ls'.
11227 16 This message could not be delivered because the initiator service has sent a message with a message type that can only be sent by the target. Message type name: '%.*ls'. Service contract name: '%.*ls'.
11228 16 This message could not be delivered because the target service has sent a message with a message type that can only be sent by the initiator. Message type name: '%.*ls'. Service contract name: '%.*ls'.
11229 16 This message could not be delivered because the security context could not be retrieved.
11230 16 This message could not be delivered because the message could not be decrypted and validated.
11231 16 This message could not be delivered because the conversation endpoint is not secured, however the message is secured.
11232 16 This message could not be delivered because the conversation endpoint is secured, however the message is not secured.
11233 16 This message has been dropped because the session key of the conversation endpoint does not match that of the message.
11234 16 This message could not be delivered because an internal error was encountered while processing it. Error code %d, state %d: %.*ls.
11235 16 Received a malformed message. The binary message class (%d:%d) is not defined. This may indicate network problems or that another application is connected to the Service Broker endpoint.
11236 16 A corrupted message has been received. The binary header size of %d is expected, however the header size received was %d.
11237 16 A %S_MSG message could not be processed due to insufficient memory. The message was dropped.
11238 16 A corrupted message has been received. The private variable data segment is malformed.
11239 16 A corrupted message has been received. The private variable data segment extends beyond the length of the message.
11240 16 A corrupted message has been received. The binary message preamble is malformed.
11241 16 A corrupted message has been received. The conversation security version number is not %d.%d.
11242 16 A corrupted message has been received. The maximum number of public variable data elements (%d) has been exceeded. Public variable data elements found: %d.
11243 16 A corrupted message has been received. The public variable data element (%d) has been duplicated in this message.
11244 16 A corrupted message has been received. The handshake validation header is malformed.
11245 16 A corrupted message has been received. The maximum number of private variable data elements (%d) has been exceeded. Private variable data elements found: %d.
11246 16 A corrupted message has been received. The private variable data element (%d) has been duplicated in this message.
11247 16 A corrupted message has been received. The login negotiate header is invalid.
11248 16 A corrupted message has been received. The SSPI login header is invalid.
11249 16 A corrupted message has been received. The pre-master-secret is invalid.
11250 16 A corrupted message has been received. The security certificate key fields must both be present or both be absent. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.

Error Severity Description
11251 16 A corrupted message has been received. The service pair security header source certificate and the signature must both be present or both be absent. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I6
11252 16 A corrupted message has been received. The destination certificate serial number is missing. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11253 16 A corrupted message has been received. The service pair security header destination certificate, the key exchange key, the key exchange key ID, and the session key must all be present or all be absent. This occurred in the message with Conversation ID '%.
11254 16 A corrupted message has been received. The session key ID is missing. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11255 16 A corrupted message has been received. The encryption flag is set, however the message body, MIC or salt is missing. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11256 16 A corrupted message has been received. The MIC is present, however the message body or encryption flag is missing. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11257 16 A corrupted message has been received. The MIC and session key ID are in an invalid state. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11258 16 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', Initiator: %d, and Message sequence number: %I64d.
11259 16 A corrupted message has been received. The certificate serial number size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11260 16 A corrupted message has been received. The certificate issuer name size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11261 16 A corrupted message has been received. The destination certificate serial number size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64
11262 16 A corrupted message has been received. The destination certificate issuer name size is %d, however it must be no greater than %d bytes in length. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11263 16 A corrupted message has been received. The service pair security header size is %d, however it must be between %d and %d bytes. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11264 16 A corrupted message has been received. The key exchange key size is %d, however it must be between %d and %d bytes. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11265 16 A corrupted message has been received. The key exchange key ID is invalid. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11266 16 A corrupted message has been received. The encrypted session key size is %d, however it must be %d bytes. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11267 16 A corrupted message has been received. The session key ID size is %d, however it must be %d bytes. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11268 16 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 sequence number: %I64d.
11269 16 A corrupted message has been received. A UNICODE string is not two byte aligned within the message. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11270 16 A corrupted message has been received. A UNICODE string is greater than the maximum allowed size of %d bytes. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11271 16 A corrupted message has been received. The conversation ID must not be NULL. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11272 16 A corrupted message has been received. The message ID must not be NULL.
11273 16 A corrupted message has been received. The message body is not properly padded for encryption. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11274 16 A corrupted message has been received. A sequence number is larger than allowed. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11275 16 A corrupted message has been received. The End of Conversation and Error flags are both set. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11276 16 A corrupted message has been received. The End of Conversation flag has been set on an unsequenced message. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11277 16 A corrupted message has been received. The End of Conversation and Error flags may not be set in the first sequenced message. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11278 16 A corrupted message has been received. The message type is missing for this message. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11279 16 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 sequence number: %I64d.
11280 16 A packet of size %lu bytes could not be processed because it exceeds the receive buffer count.
11281 16 A corrupted message has been received. The private portion of the message header is malformed.
11282 16 This message has been dropped due to licensing restrictions. See the documentation for further details.
11285 16 This forwarded message has been dropped because the hops remaining count has reached 0.
11286 16 Dropped this forwarded message because this SQL Server instance is out of memory.
11288 16 This forwarded message has been dropped because a duplicate message is already being forwarded.
11289 16 This forwarded message has been dropped because its memory usage would exceed the configured memory limit of %d bytes for forwarded messages.
11290 16 This forwarded message was dropped because the message could not be delivered within the message time to live. This may indicate that the forwarding route is incorrectly configured or that the destination is unavailable.
11291 16 This forwarded message has been dropped because the time consumed has exceeded the message's time to live of %u seconds (the message arrived with %u seconds consumed and used %u seconds in this broker).
11292 16 The forwarded message has been dropped because a transport send error occurred when sending the message. Check previous events for the error.
11293 16 This forwarded message has been dropped because a transport is shutdown.
11294 16 This forwarded message has been dropped because the destination route is not valid.
11295 10 Endpoint configuration change detected. Service Broker manager and transport will now restart.
11296 10 Certificate change detected. Service Broker manager and transport will now restart.
11297 16 A corrupted message has been received. The private variable data segment offset is incorrect.
11298 16 A corrupted message has been received. The public variable data segment offset is incorrect.
11299 10 A corrupted message has been received. An unsequenced message had a non-zero sequence number. This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
11300 10 Error wile committing a readonly or a TEMPDB XDES, Shutting down the server.
11301 10 Error while performing transaction notification for object %p event %d.
11302 10 Error during rollback. shutting down database (location: %d).
11303 10 Error releasing reserved log space: %ls space %I64d, code %d, state %d.
11304 10 Failed to record outcome of a local two-phase commit transaction. Taking database offline.
11306 16 Forward progress on this transaction is disallowed. Transaction has been rolled back.
11313 16 This operation must be executed within a parallel nested transaction.
11314 16 The stored procedure %.*ls must be executed within a user transaction.
11315 16 The isolation level specified for the PNT child transaction does not match the current isolation level for the parent.
11316 16 %ls statement cannot be used inside a parallel nested transaction.
11317 16 Parallel plan with updates is not supported inside a parallel nested transaction.
11318 16 The stored procedure '%.*ls' cannot be executed through MARS connection.
11319 16 Bound sessions and user parallel nested transactions cannot be used in the same transaction.
11320 16 Cannot create a User Parallel Nested Transaction, the maximum number of parallel nested transactions is reached.
11321 16 This operation cannot be executed within an active transaction.
11400 16 ALTER TABLE SWITCH statement failed. Index '%.*ls' on indexed view '%.*ls' uses partition function '%.*ls', but table '%.*ls' uses non-equivalent partition function '%.*ls'. Index on indexed view '%.*ls' and table '%.*ls' must use an equivalent partition
11401 16 ALTER TABLE SWITCH statement failed. Table '%.*ls' is %S_MSG, but index '%.*ls' on indexed view '%.*ls' is %S_MSG.
11402 16 ALTER TABLE SWITCH statement failed. Target table '%.*ls' is referenced by %d indexed view(s), but source table '%.*ls' is only referenced by %d indexed view(s). Every indexed view on the target table must have at least one matching indexed view on the so
11403 16 ALTER TABLE SWITCH statement failed. Indexed view '%.*ls' is not aligned with table '%.*ls'. The partitioning column '%.*ls' from the indexed view calculates its value from one or more columns or an expression, rather than directly selecting from the tabl
11404 16 ALTER TABLE SWITCH statement failed. Target table '%.*ls' is referenced by %d indexed view(s), but source table '%.*ls' is only referenced by %d matching indexed view(s). Every indexed view on the target table must have at least one matching indexed view
11405 16 ALTER TABLE SWITCH statement failed. Table '%.*ls' is not aligned with the index '%.*ls' on indexed view '%.*ls'. The table is partitioned on column '%.*ls', but the index on the indexed view is partitioned on column '%.*ls', which is selected from a diff
11406 16 ALTER TABLE SWITCH statement failed. Source and target partitions have different values for the DATA_COMPRESSION option.
11407 16 Vardecimal storage format can not be enabled for '%.*ls'. Only Enterprise edition of SQL Server supports vardecimal.
11408 16 Cannot modify the column '%.*ls' in the table '%.*ls' to add or remove the COLUMN_SET attribute. To change a COLUMN_SET attribute of a column, either modify the table to remove the column and then add the column again, or drop and re-create the table.
11409 16 Cannot remove the column set '%.*ls' in the table '%.*ls' because the table contains more than 1025 columns. Reduce the number of columns in the table to less than 1025.
11410 16 Cannot modify the column '%.*ls' in the table '%.*ls' to a sparse column because the column has a default or rule bound to it. Unbind the rule or default from the column before designating the column as sparse.
11411 16 Cannot add the sparse column '%.*ls' to the table '%.*ls' because the data type of the column has a default or rule bound to it. Unbind the rule or default from the data type before adding the sparse column to the table.
11412 16 ALTER TABLE SWITCH statement failed because column '%.*ls' does not have the same sparse storage attribute in tables '%.*ls' and '%.*ls'.
11413 16 ALTER TABLE SWITCH statement failed because column '%.*ls' does not have the same column set property in tables '%.*ls' and '%.*ls'.
11414 10 Warning: Option %ls is not applicable to table %.*ls because it does not have a clustered index. This option will be applied only to the table's nonclustered indexes, if it has any.
11415 16 Object '%.*ls' cannot be disabled or enabled. This action applies only to foreign key and check constraints.
11418 16 Cannot %S_MSG table '%.*ls' because the table either contains sparse columns or a column set column which are incompatible with compression.
11419 16 Cannot alter or drop column '%.*ls' because the table '%.*ls' is federated on it.

Related Articles :