Skip Navigation Links
Home
Articles
SQL Server 2012
SQL Server 2014
SQL Server 2016
FAQ
Practice Test
Tip of the Day : SQL Server Database Design - Twitter Profile and Followers
Error Messages
Home > Tips & Tricks > Error Messages 9501 to 10000
SQL Server Error Messages - Errors 9501 to 10000

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
9501 16 XQuery: Unable to resolve sql:variable('%.*ls'). The variable must be declared as a scalar TSQL variable.
9502 16 The string literal provided for the argument %d of the '%.*ls' method must not exceed %d bytes.
9503 16 Errors and/or warnings occurred when processing the XQuery statement for XML data type method '%.*ls'. See previous error messages for more details.
9504 16 Errors and/or warnings occurred when processing the XQuery statement for XML data type method '%.*ls', invoked on column '%.*ls', table '%.*ls'. See previous error messages for more details.
9506 16 The XMLDT method '%.*ls' can only be invoked on columns of type xml.
9507 16 The XML data type method on a remote column used in this query can not be executed either locally or remotely. Please rewrite your query.
9508 16 The reference parameter given to XMLDT method '%.*ls' was generated from a different XML instance than the one it is being applied to.
9509 16 XMLUNNEST method requires typed xml column with single global element
9510 16 Functionality not yet implemented: XMLNODEREFS cannot use references exposed by views.
9512 16 Xml data type is not supported as a parameter to remote calls.
9513 16 Error processing XML data type method '%.*ls'. The following SET options required by XML data type methods are not set: '%.*ls'.
9514 16 Xml data type is not supported in distributed queries. Remote object '%.*ls' has xml column(s).
9515 16 An XML schema has been altered or dropped, and the query plan is no longer valid. Please rerun the query batch.
9516 16 XQuery: The name or one of the parts of a multi-part name supplied to %S_MSG('%.*ls') is empty. Empty names cannot be used to identify objects, columns or variables in SQL.
9517 16 XQuery: The name or one of the parts of a multi-part name that starts with '%.*ls' supplied to %S_MSG() is not a valid SQL identifier - it is too long. Maximum length is %d, actual length is %d.
9518 16 XQuery: The name or one of the parts of a multi-part name that starts with '%.*ls' supplied to %S_MSG() is not a valid SQL identifier - it contains invalid characters.
9519 16 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.
9520 16 XQuery: '%.*ls' referenced by sql:variable() is not a valid system function name.
9521 16 Error processing XML data type. The XML data type instance contains a negative xs:date or xs:dateTime value.
9522 16 The XQuery modify method is not allowed on sparse column sets.
9523 16 Cannot update the sparse column set '%.*ls' because the XML content supplied references the non-sparse column '%.*ls' which does not belong to this column set. The XML data used to update a sparse column set cannot reference columns that don't belong to t
9524 16 The XML content provided does not conform to the required XML format for sparse column sets.
9525 16 The XML content that is supplied for the sparse column set '%.*ls' contains duplicate references to the column '%.*ls'. A column can only be referenced once in XML content supplied to a sparse column set.
9526 16 In the XML content that is supplied for the sparse column set '%.*ls', the '%.*ls' attribute value on the element '%.*ls' is out of range. The valid range is from 1 to %d.
9527 16 In the XML content that is supplied for the column set '%.*ls', the sqltypes:scale attribute value on the element '%.*ls' is out of range. The valid range for the scale is from 0 to the specified precision.
9528 16 In the XML content that is supplied for the column set '%.*ls', the '%.*ls' attribute on the element '%.*ls' is not valid. The attribute is valid only for sparse columns of data type sql_variant.
9529 16 In the XML content that is supplied for the column set column '%.*ls', the sqlDBType:base64Encoded attribute on the element '%.*ls' is not valid. The base64Encoded attribute can only be used when the corresponding sparse column is of character data type (
9530 16 In the XML content that is supplied for the column set column '%.*ls, the '%.*ls' attribute on the element '%.*ls' is not valid. Remove the attribute.
9531 16 In the XML content that is supplied for the column set column '%.*ls', the '%.*ls' attribute value on the element '%.*ls' is not valid.
9532 16 In the query/DML operation involving column set '%.*ls', conversion failed when converting from the data type '%ls' to the data type '%ls' for the column '%.*ls'.
9533 16 In the XML that is supplied for the column set '%.*ls', the element '%.*ls' should reside in the global namespace. Remove the default namespace declaration or the prefix on the element.
9534 16 In the query/DML operation involving column set '%.*ls', conversion failed when converting from the data type '%ls' to the data type '%ls' for the column '%.*ls'. Please refer to the Books-on-line for more details on providing XML conversion methods for
9601 16 Cannot relate to %S_MSG %.*ls because it is %S_MSG.
9602 16 Failed to start a system task with error code %d, state %d.
9605 10 Conversation Priorities analyzed: %d.
9606 16 The conversation priority with ID %d has been dropped.
9607 16 The conversation priority with ID %d is referencing the missing service with ID %d.
9608 16 The conversation priority with ID %d is referencing the missing service contract with ID %d.
9609 16 The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.
9610 16 The service '%.*ls' in the FROM SERVICE clause must match the service '%.*ls' referenced by %s = '%.*ls'.
9611 16 Cannot find the specified user '%.*ls'.
9613 16 The queue '%.*ls' cannot be activated because the activation user is not specified.
9614 16 The queue '%.*ls' cannot be activated because the activation stored procedure is either not specified or is invalid.
9615 16 A message of type '%.*ls' failed XML validation on the target service. %.*ls This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
9616 16 A message of type '%.*ls' was received and failed XML validation. %.*ls This occurred in the message with Conversation ID '%.*ls', Initiator: %d, and Message sequence number: %I64d.
9617 16 The service queue "%.*ls" is currently disabled.
9618 16 The message cannot be sent because the service queue '%.*ls' associated with the dialog is currently disabled and retention is on.
9619 16 Failed to create remote service binding '%.*ls'. A remote service binding for service '%.*ls' already exists.
9620 16 The activation stored procedure '%.*ls' is invalid. Functions are not allowed.
9621 16 An error occurred while processing a message in the Service Broker and Database Mirroring transport: error %i, state %i.
9622 16 The crypto provider context is not initialized.
9623 16 The key passed in for this operation is in the wrong state.
9624 16 The key size is unacceptable for this key object.
9625 16 The key buffer size is inconsistent with the key modulus size.
9626 16 An internal Service Broker error occurred: an object is in the wrong state for this operation. This error indicates a serious problem with SQL Server. Check the SQL Server error log and the Windows event logs for information pointing to possible hardware
9627 16 The hash buffer size is not correct for initializing the hash object.
9628 16 The encryption/decryption data buffer size is not 8 byte aligned.
9629 16 The decrypted signature size is wrong.
9630 16 The signature did not verify the internal hash.
9631 16 The salt size is unacceptable for this key object.
9632 16 The salt buffer size is too small.
9633 16 The passed in name is too long.
9634 16 Service Broker was unable to allocate memory for cryptographic operations. This message is a symptom of another problem. Check the SQL Server error log for additional messages, and address the underlying problem.
9635 16 The certificate is not valid at this point in time.
9636 16 The requested object was not found.
9637 16 The passed in serialized object is incorrectly encoded.
9638 16 The cer or pvk file size is too large.
9639 16 A password was supplied and the pvk file is not encrypted.
9640 16 The operation encountered an OS error.
9641 16 A cryptographic operation failed. This error indicates a serious problem with SQL Server. Check the SQL Server error log and the Windows event logs for further information.
9642 16 An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: %i, State: %i. (Near endpoint role: %S_MSG, far endpoint address: '%.*hs')
9643 16 An error occurred in the Service Broker/Database Mirroring transport manager: Error: %i, State: %i.
9644 16 An error occurred in the service broker message dispatcher. Error: %i, State: %i.
9645 16 An error occurred in the service broker manager, Error: %i, State: %i.
9646 16 An error occurred in the timer event cache. Error %i, state %i.
9647 16 Received a malformed message from the network. Unable to retrieve a broker message attribute from a message destined for database ID %d. This may indicate a network problem or that another application connected to the Service Broker endpoint.
9648 20 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 16 A security (SSPI) error occurred when connecting to another service broker: '%.*ls'. Check the Windows Event Log for more information.
9650 16 A system cryptographic call failed during a Service Broker or Database Mirroring operation: system error '%ls'.
9651 16 The system call failed during a Service Broker or Database Mirroring operation. System error: '%ls'.
9652 16 Service Broker failed to retrieve the session key for encrypting a message.
9653 16 The signature of activation stored procedure '%.*ls' is invalid. Parameters are not allowed.
9654 16 Attempting to use database and it doesn't exist.
9655 16 The transmission queue table structure in database is inconsistent. Possible database corruption.
9656 16 An error occurred in the service broker multicast manager, Error: %i, State: %i.
9657 23 The structure of the Service Broker transmission work-table in tempdb is incorrect or corrupt. This indicates possible database corruption or hardware problems. Check the SQL Server error log and the Windows event logs for information on possible hardware
9658 16 Cannot access the transmission queue table in database.
9659 16 The %s of route '%.*ls' cannot be empty.
9660 16 The %s of route '%.*ls' must be less than %d characters long.
9661 16 The SERVICE_NAME and BROKER_INSTANCE of route "%.*ls" must be specified when using mirroring.
9662 16 Cannot specify BROKER_INSTANCE without SERVICE_NAME in route "%.*ls".
9663 16 The system object cannot be modified.
9666 10 The %S_MSG endpoint is in disabled or stopped state.
9667 10 Services analyzed: %d.
9668 10 Service Queues analyzed: %d.
9669 10 Conversation Endpoints analyzed: %d.
9670 10 Remote Service Bindings analyzed: %d.
9671 16 Messages with conversation ID '%ls' have been removed from the transmission queue.
9672 16 Messages with conversation handle '%ls' and conversation group '%ls' have been removed from the queue with ID %d.
9673 16 Activation has been disabled on the queue with ID %d.
9674 10 Conversation Groups analyzed: %d.
9675 10 Message Types analyzed: %d.
9676 10 Service Contracts analyzed: %d.
9677 16 The service contract with ID %d is referencing the missing message type with ID %d.
9678 16 The service with ID %d is referencing the missing service contract with ID %d.
9679 16 The service with ID %d is referencing the missing service queue with ID %d.
9680 16 The conversation endpoint '%ls' is referencing the missing conversation group '%ls'.
9681 16 The conversation endpoint with ID '%ls' and is_initiator: %d is referencing the missing service contract with ID %d.
9682 16 The conversation endpoint with ID '%ls' and is_initiator: %d is referencing the missing service with ID %d.
9683 16 The conversation group '%ls' is referencing the missing service with ID %d.
9684 16 The service with ID %d has been dropped.
9685 16 The service contract with ID %d has been dropped.
9686 16 The conversation endpoint with handle '%ls' has been dropped.
9687 16 The conversation group '%ls' has been dropped.
9688 10 Service Broker manager has started.
9689 10 Service Broker manager has shut down.
9690 10 The %S_MSG endpoint is now listening for connections.
9691 10 The %S_MSG endpoint has stopped listening for connections.
9692 16 The %S_MSG endpoint cannot listen on port %d because it is in use by another process.
9693 16 The %S_MSG endpoint cannot listen for connections due to the following error: '%.*ls'.
9694 16 Could not start Service Broker manager. Check the SQL Server error log and the Windows error log for additional error messages.
9695 16 Could not allocate enough memory to start the Service Broker task manager. This message is a symptom of another problem. Check the SQL Server error log for additional messages, and address the underlying problem.
9696 16 Cannot start the Service Broker primary event handler. This error is a symptom of another problem. Check the SQL Server error log for additional messages, and address this underlying problem.
9697 10 Could not start Service Broker for database id: %d. A problem is preventing SQL Server from starting Service Broker. Check the SQL Server error log for additional messages.
9698 16 Cannot start Service Broker security manager. This message is a symptom of another problem. Check the SQL Server error log and the Windows event log for additional messages, and address the underlying problem.
9699 16 Could not allocate memory for extra Service Broker tasks while adding CPUs.
9701 16 Cannot start Service Broker activation manager. This message is a symptom of another problem. Check the SQL Server error log and the Windows event log for additional messages and address the underlying problem.
9704 16 This message could not be delivered because it failed XML validation. This failure occurred while the message was being delivered to the target service.
9705 16 The messages in the queue with ID %d are referencing the invalid conversation handle '%ls'.
9706 16 The stored procedure with ID %d is invalid but is referenced by the queue with ID %d.
9707 16 The activation user with ID %d is invalid but is referenced by queue with ID %d.
9708 16 The messages in the queue with ID %d are referencing the invalid conversation group '%ls'.
9709 16 The messages in the queue with ID %d are referencing the invalid message type with ID %d.
9710 16 The conversation endpoint with ID '%ls' and is_initiator: %d is referencing the invalid conversation group '%ls'.
9711 16 The transmission queue is referencing the invalid conversation ID '%ls'.
9712 16 The remote service binding with ID %d is referencing the invalid service contract with ID %d.
9713 16 The message type with ID %d is referencing the invalid XML schema collection ID %d.
9715 16 The conversation endpoint with conversation handle '%ls' is in an inconsistent state. Check the SQL Server error logs and the Windows event logs for information on possible hardware problems. To recover the database, restore the database from a clean back
9716 16 The conversation group '%ls' reports references to %d conversation handle(s), but actually references %d.
9717 16 Cannot enable stored procedure activation on queue '%.*ls'. Event notification for queue_activation is already configured on this queue.
9718 16 Cannot create event notification for queue_activation on queue "%.*ls". Stored procedure activation is already configured on this queue.
9719 16 The database for this conversation endpoint is attached or restored.
9720 16 The database for the remote conversation endpoint is attached or restored.
9721 10 Service broker failed to clean up conversation endpoints on database '%.*ls'. Another problem is preventing SQL Server from completing this operation. Check the SQL Server error log for additional messages.
9723 10 The database "%i" will not be started as the broker due to duplication in the broker instance ID.
9724 10 The activated proc '%ls' running on queue '%ls' output the following: '%.*ls'
9725 16 The invalid schema has been dropped from the message type with ID %d.
9726 16 The remote service binding with ID %d has been dropped.
9727 16 Dialog security is not available for this conversation because there is no remote service binding for the target service. Create a remote service binding, or specify ENCRYPTION = OFF in the BEGIN DIALOG statement.
9728 16 Cannot find the security certificate because the lookup database principal ID (%i) is not valid. The security principal may have been dropped after the conversation was created.
9730 16 Cannot find the security certificate because the lookup database principal (Id: %i) does not correspond to a server principal. The security principal may have been dropped after the conversation was created.
9731 16 Dialog security is unavailable for this conversation because there is no security certificate bound to the database principal (Id: %i). Either create a certificate for the principal, or specify ENCRYPTION = OFF when beginning the conversation.
9733 16 There is no private key for the security certificate bound to database principal (Id: %i). The certificate may have been created or installed incorrectly. Reinstall the certificate, or create a new certificate.
9734 16 The length of the private key for the security certificate bound to database principal (Id: %i) is incompatible with the Windows cryptographic service provider. The key length must be a multiple of 64 bytes.
9735 16 The length of the public key for the security certificate bound to database principal (Id: %i) is incompatible with the Windows cryptographic service provider. The key length must be a multiple of 64 bytes.
9736 16 An error occurred in dialog transmission: Error: %i, State: %i. %.*ls
9737 16 The private key for the security certificate bound to the database principal (ID %i) is password protected. Password protected private keys are not supported for use with secure dialogs.
9738 16 Cannot create task for Service Broker message dispatcher. This message is a symptom of another problem that is preventing SQL Server from creating tasks. Please check the SQL Server error log and the Windows event log for additional messages.
9739 16 Message transmitter in service broker message dispatcher failed %d times
9740 16 Cannot start the Service Broker message dispatcher. This error is a symptom of another problem. Check the SQL Server error log and the Windows event log for additional messages, and address this underlying problem.
9741 10 The %S_MSG '%.*ls' was dropped on upgrade because it referenced a system contract that was dropped.
9742 16 The activation stored procedure '%.*ls' is invalid. Temporary procedures may not be configured for activation.
9743 16 The %s of route "%.*ls" must be an address when using mirroring.
9744 16 The %s of route "%.*ls" is not a valid address.
9745 16 The ADDRESS of route '%.*ls' cannot be 'TRANSPORT' when SERVICE_NAME is specified.
9746 16 The LIFETIME of route '%.*ls' must be in the range %d to %d.
9747 16 The ADDRESS and MIRROR_ADDRESS of route '%.*ls' cannot be the same.
9748 10 The %S_MSG protocol transport is not available.
9749 10 Target queue is busy; message(s) queued for delivery.
9750 10 No route matches the destination service name for this conversation. Create a route to the destination service name for messages in this conversation to be delivered.

Error Severity Description
9751 10 Authentication failed with error: '%.*ls'.
9752 10 %S_MSG connection was refused. The user account of the remote server is not permitted to log in to this SQL Server: User account: '%.*ls', IP address: '%.*hs'.
9753 10 The target service broker is unreachable.
9754 10 Connection attempt failed with error: '%.*ls'.
9755 10 An error occurred while receiving data: '%.*ls'.
9756 10 An internal exception occurred while connecting to an adjacent broker: Error: %i, State: %i. %.*ls
9757 10 Service Broker/Database Mirroring network protocol error occurred.
9758 10 Login protocol negotiation error occurred.
9759 10 An error occurred while sending data: '%.*ls'.
9760 10 The connection has been idle for over %d seconds.
9761 16 The Broker Configuration conversation on dialog handle '%s' closed due to an error. To troubleshoot this problem, investigate the error: '%.*ls'.
9762 10 An error occurred while looking up the public key certificate associated with this SQL Server instance: No certificate was found.
9763 10 An error occurred while looking up the public key certificate associated with this SQL Server instance: The certificate found is not valid at the current time.
9764 10 An error occurred while looking up the public key certificate associated with this SQL Server instance: The certificate found is too large.
9765 10 An error occurred while looking up the public key certificate associated with this SQL Server instance: The certificate found has no associated private key.
9766 10 An unknown internal error (%d) occurred while looking up the public key certificate associated with this SQL Server instance.
9767 16 The security certificate bound to database principal (Id: %i) has been disabled for use with BEGIN DIALOG. See the Books Online topics "Certificates and Service Broker" for an overview and "ALTER CERTIFICATE (Transact-SQL)" for syntax to make a certificat
9768 16 A database user associated with the secure conversation was dropped before credentials had been exchanged with the far endpoint. Avoid using DROP USER while conversations are being created.
9769 10 Insufficient memory prevented the Service Broker/Database Mirroring Transport Manager from starting.
9770 10 Locating routes and security information via the Broker Configuration Service.
9771 10 The service broker manager is disabled in single-user mode.
9772 16 The Service Broker in database "%.*ls" cannot be enabled because there is already an enabled Service Broker with the same ID.
9773 10 The Service Broker in database "%d" is disabled because there is already an enabled Service Broker with the same ID.
9774 10 Cannot create a new Service Broker in the attached read-only database "%.*ls". The Service Broker will be disabled.
9775 16 Cannot create a new Service Broker in read-only database "%.*ls".
9776 16 Cannot enable the Service Broker in database "%.*ls" because the Service Broker GUID in the database (%s) does not match the one in sys.databases (%s).
9777 10 The Service Broker in database "%.*ls" will be disabled because the Service Broker GUID in the database (%s) does not match the one in sys.databases (%s).
9778 16 Cannot create a new Service Broker in a mirrored database "%.*ls".
9779 10 Service Broker received an END CONVERSATION message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.
9780 10 The service broker manager is initializing.
9781 10 The service broker manager is shutting down.
9782 10 An internal exception occurred while dispatching a message: Error: %i, State: %i. %.*ls
9783 10 DNS lookup failed with error: '%.*ls'.
9784 10 Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.
9785 10 Invalid address specified: '%.*ls'.
9786 10 Cannot retrieve user name from security context. Error: '%.*ls'. State: %hu.
9787 10 An error occurred while processing broker mirroring routes. Error: %i. State: %i.
9788 10 Unable to route the incoming message. The system database msdb containing routing information is not available.
9789 10 Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb.
9790 10 Unable to route the incoming message. The system database msdb containing routing information is in SINGLE USER mode.
9791 10 The broker is disabled in the sender's database.
9792 10 Could not forward the message because forwarding is disabled in this SQL Server instance.
9793 10 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 The broker mirroring manager has not fully initialized.
9795 10 Could not find the target broker in the local SQL Server instance.
9796 10 The target service name matched a LOCAL route, but there is no service by that name in the local SQL Server instance.
9797 10 Classification has been delayed because the routing information is currently being updated.
9798 16 The message could not be delivered because it could not be classified. Enable broker message classification trace to see the reason for the failure.
9799 10 The connection was closed by the remote end, or an error occurred while receiving data: '%.*ls'
9801 16 Error converting %.*ls to %ls. The result would be truncated.
9802 16 The locale identifier (LCID) %d is not supported by SQL Server.
9803 16 Invalid data for type "%ls".
9804 16 Column or parameter #%d: Invalid fractional second precision %d specified for %ls data type. The maximum fractional second precision is %d.
9805 10 Warning: converting %ls to %ls caused a loss of information.
9806 16 The datepart %.*ls is not supported by date function %.*ls.
9807 16 The input character string does not follow style %d, either change the input character string or use a different style.
9808 16 This session's YDM date format is not supported when converting from this character string format to date, time, datetime2 or datetimeoffset. Change the session's date format or provide a style to the explicit conversion.
9809 16 The style %d is not supported for conversions from %s to %s.
9810 16 The datepart %.*ls is not supported by date function %.*ls for data type %s.
9811 16 The system timezone information could not be retrieved.
9812 16 The timezone provided to builtin function %.*ls is invalid.
9813 16 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 The date provided is before the start of the Hijri calendar which in Microsoft's 'Kuwaiti Algorithm' is July 15th, 622 C.E. (Julian calendar) or July 18th, 622 C.E (proleptic Gregorian calendar).
9815 16 Waitfor delay and waitfor time cannot be of type %s.
9816 16 The number of columns in the column set exceeds 2048. Reduce the number of columns that are referenced in the column set.
9817 16 The specified column set value causes the estimated row size to be at least %d bytes. This exceeds the maximum allowed row size of %d bytes. To reduce the row size, reduce the number of columns specified in the column set.
9818 16 The culture parameter '%.*ls' provided in the function call is not supported.
9819 16 Error converting string value '%.*ls' into data type %ls using culture '%.*ls'.
9901 16 Full-text catalog '%ls' ('%d') in database '%ls' ('%d') is low on disk space. Pausing all populations in progress until more space becomes available. Reason code: %d. Error: %ls. To resume populations, free up disk space.
9902 10 Full-text catalog '%ls' ('%d') in database '%ls' ('%d') is low on system resources. Any population in progress will be paused until more resources become available. Reason code: %d. Error: %ls. If this message occurs frequently, try to serialize full-text
9903 10 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-progress population from the previous checkpoint. If this message occurs frequentl
9904 10 The full-text catalog '%ls' (%d) in database '%ls' (%d) will be remounted to recover from a failure. Reason code: %d. Error: %ls. If this message occurs frequently, consult SQL Server Books Online for troubleshooting assistance. This is an informational m
9905 10 Informational: Full-text indexer requested status change for catalog '%ls' ('%d') in database '%ls' ('%d'). New Status: %ls, Reason: %ls (%ls).
9906 10 The full-text catalog monitor reported catalog '%ls' (%d) in database '%ls' (%d) in %ls state. This is an informational message only. No user action is required.
9907 10 Error: Total number of items in full-text catalog ID '%d' in database ID '%d' exceeds the supported limit. See Books Online for troubleshooting assistance.
9908 10 Changing the status to %ls for full-text catalog '%ls' (%d) in database '%ls' (%d). This is an informational message only. No user action is required.
9909 10 Warning: Failed to change the status to %ls for full-text catalog '%ls' (%d) in database '%ls' (%d). Error: %ls.
9910 10 Warning: Error occurred during full-text %ls population for table or indexed view '%ls', database '%ls' (table or indexed view ID '%d', database ID '%d'). Error: %ls.
9911 10 Informational: Full-text %ls population initialized for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'). Population sub-tasks: %d.
9912 10 Error: Failed to initialize full-text %ls population for table or indexed view '%ls', database '%ls' (table or indexed view ID '%d', database ID '%d'). Error: %d.
9913 10 Informational: Resuming full-text population for table or indexed view '%ls' in database '%ls' (table or indexed view ID '%d', database ID '%d'). Prior number of documents processed: %d, error encountered: %d.
9914 16 Error: Failed to resume full-text %ls population for table or indexed view '%ls' in database '%ls' (table or indexed view ID '%d', database ID '%d'). Error: 0x%x. Repeat the operation that triggered the resume, or drop and re-create the index.
9915 10 Reinitialized full-text %ls population for table '%ls' (table ID '%d', database ID '%d') after a temporary failure. Number of documents processed prior to failure: %d, errors encountered: %d. This is an informational message only. No user action is requir
9916 10 Error: Failed to reinitialize full-text %ls population after a temporary failure for table or indexed view '%ls', database '%ls' (table or indexed view ID '%d', database ID '%d'). Error: %d.
9917 17 An internal error occurred in full-text docid mapper.
9918 10 Warning: Full-text catalog '%ls' uses FAT volume. Security and differential backup are not supported for the catalog.
9919 16 Fulltext DDL command failed because SQL Server was started in single user mode.
9920 10 Warning: Failed to get MSFTESQL indexer interface for full-text catalog '%ls' ('%d') in database '%ls' ('%d'). Error: %ls.
9921 16 During upgrade fatal error 0x%x encountered in CoCreateGuid. Failed to resolve full-text catalog file name for '%ls'.
9922 10 Warning: Full-text population for table or indexed view '%ls' failed to send batch of data to MSFTESQL service (table or indexed view ID '%d', catalog ID '%d', database ID '%d'). Error: %ls.
9923 10 Warning: Full-text population for table or indexed view '%ls' reported low resources while sending a batch of data to MSFTESQL service (table or indexed view ID '%d', catalog ID '%d', database ID '%d'). Error: %ls.
9924 16 Rebuild full-text catalog '%ls' failed: Catalog header file is read-only.
9925 16 Rebuild full-text catalog '%ls' failed: Full-text catalog is read-only.
9926 10 Informational: MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
9927 10 Informational: The full-text search condition contained noise word(s).
9928 16 Computed column '%.*ls' cannot be used for full-text search because it is nondeterministic or imprecise nonpersisted computed column.
9929 16 Computed column '%.*ls' cannot be used as full-text type column for image or varbinary(MAX) column. This computed column must be deterministic, precise or persisted, with a size less or equal than %d characters.
9930 10 Null document type provided. Row will not be full-text indexed.
9931 10 Document type exceeds the maximum permitted length. Row will not be full-text indexed.
9932 10 Document type value is malformed. Row will not be full-text indexed.
9933 10 Internal error: The row cannot be full-text indexed. The protocol handler was invoked out of sequence. This is an informational message only. No user action is required.
9934 10 Row was not found. It was deleted or updated while indexing was in progress.
9935 10 Warning: Wordbreaker, filter, or protocol handler used by catalog '%ls' does not exist on this instance. Use sp_help_fulltext_catalog_components and sp_help_fulltext_system_components check for mismatching components. Rebuild catalog is recommended.
9936 10 Informational: No full-text supported languages found.
9937 16 Too many full-text columns or the full-text query is too complex to be executed.
9938 16 Cannot find the specified user or role '%.*ls'.
9939 16 Current user or role '%.*ls' does not have the required permission to set the owner.
9940 10 Error: Full-text %ls population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d') is terminated due to the preceding error.
9941 10 Informational: Full-text %ls population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d') is being suspended by the system as the database is unavailable. System will resume the population whenever the database is available
9942 10 Informational: Full-text %ls population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d') was cancelled by user.
9943 10 Informational: Full-text %ls population completed for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'). Number of documents processed: %d. Number of documents failed: %d. Number of documents that will be retried: %d.
9944 10 Informational: Full-text retry pass of %ls population completed for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'). Number of retry documents processed: %d. Number of documents failed: %d.
9945 10 Error: All Full-text populations in progress, for catalog '%ls' ('%d') in database '%ls' ('%d') were terminated due to error. Error: 0x%x.
9947 10 Warning: Identity of full-text catalog in directory '%ls' does not match database '%.*ls'. The full-text catalog cannot be attached.
9948 10 Warning: Full-text catalog path '%ls' is invalid. It exceeds the length limit, or it is a relative path, or it is a hidden directory, or it is a UNC PATH. The full-text catalog cannot be attached, rebuild the catalog to resolve it.
9949 10 Warning: All Full-text populations in progress for full-text catalog '%ls' ('%d') in database '%ls' ('%d') are paused. Reason code: %d. Error: %ls. If this message occurs frequently, consult Books Online for indexing performance tuning assistance.
9950 10 Informational: Full-text catalog health monitor reported a failure for catalog '%ls' ('%d') in database '%ls' ('%d'). Reason code: %d. Error: %ls. The catalog is corrupted and all in-progress populations will be stopped. Use rebuild catalog to recover the
9951 10 Warning: Database %.*ls cannot be modified during detach because database is in read-only, standby, or shutdown state. Full-text catalog is not dropped, and '@keepfulltextindexfile = false' is ignored.
9952 10 Informational: Full-text auto change tracking is turned off for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d') due to fatal crawl error.
9953 16 The path '%.*ls' has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive.
9954 16 SQL Server failed to communicate with filter daemon launch service (Windows error: %ls). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
9955 16 SQL Server failed to create named pipe '%ls' to communicate with the full-text filter daemon (Windows error: %d). Either a named pipe already exists for a filter daemon host process, the system is low on resources, or the security identification number (S
9959 16 Cannot perform requested task because full-text memory manager is not initialized.
9960 16 View '%.*ls' is not an indexed view. Full-text index is not allowed to be created on it.
9961 16 Logical name, size, maxsize, filegrowth, and offline properties of full-text catalog cannot be modified.
9962 16 Failed to move full-text catalog from '%ls' to '%ls'. OS error '%ls'.
9963 10 Inconsistent accent sensitivity of full-text catalog is detected. Full-text catalog for catalog ID '%d', database ID '%d' is reset.
9964 16 Failed to finish full-text operation. Filegroup '%.*ls' is empty, read-only, or not online.
9965 16 NULL or Invalid type of value specified for '%ls' parameter.
9966 16 Cannot use full-text search in master, tempdb, or model database.
9967 10 A default full-text catalog does not exist in database '%.*ls' or user does not have permission to perform this action.
9968 10 Warning: No appropriate filter was found during full-text index population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'), full-text key value '%ls'. Some columns of the row were not indexed.
9969 10 Warning: No appropriate wordbreaker was found during full-text index population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'), full-text key value '%ls'. Neutral wordbreaker was used for some columns of the row.
9970 16 Couldn't complete full-text operation because full-text key for table or indexed view '%.*ls' is offline.
9971 10 Warning: No appropriate filter for embedded object was found during full-text index population for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d'), full-text key value '%ls'. Some embedded objects in the row could not be inde
9972 16 Database is not fully started up or it is not in an ONLINE state. Try the full-text DDL command again after database is started up and becomes ONLINE.
9973 10 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. Number of documents failed: %d.
9974 10 Warning: Only running full population can be paused. The command is ignored. Other type of population can just be stopped and it will continue when your start the same type of crawl again.
9975 10 Warning: Only paused full population can be resumed. The command is ignored.
9977 10 Warning: Last population complete time of full-text catalog in directory '%ls' does not match database '%.*ls'. The full-text catalog is attached and it may need to be repopulated.
9978 10 Warning: During upgrade full-text index on table '%ls' is disabled because at least one of full-text key column, full-text columns, or type columns is a non-deterministic or imprecise nonpersisted computed column.
9979 10 Warning: During upgrade full-text catalog '%ls' in database '%ls' is set as offline because it failed to be created at path '%ls'. Please fix the full-text catalog path and rebuild the full-text catalog after upgrade.
9980 16 Variable parameters can not be passed to fulltext predicates: contains, freetext and functions: containstable, freetexttable applied to remote table.
9982 16 Cannot use full-text search in user instance.
9983 16 The value '%ls' for the full-text component '%ls' is longer than the maximum permitted (%d characters). Please reduce the length of the value.
9984 10 Informational: Full-text %ls population paused for table or indexed view '%ls' (table or indexed view ID '%d', database ID '%d').
9985 16 There is not enough memory to generate a search property list cache. Rerun your full-text indexing statement when more resources are available.
9986 16 A search property list cache cannot be generated during full-text indexing. Attempting to query the registered search properties caused an internal error as indicated by the HRESULT error code, ((HRESULT = '0x%08x').
9987 15 The max gap argument in NEAR clause must be either the word MAX or an integer greater than or equal to 0.
9988 15 The number of query terms in NEAR clause must be less than or equal to 64.
9998 16 The column '%.*ls' cannot be added to a full-text index. Full-text indexes are limited to 1024 columns. When you create a full-text index, add fewer columns.
9999 16 The column '%.*ls' in the table '%.*ls' cannot be used for full-text search because it is a sparse column set.
10000 16 Unknown provider error.

Related Articles :