SQL Server Error Messages 9001 to 10000

In this post, we’ll list out the SQL Server Error Messages from the error codes 9001 to 10000 and references to the detailed post to know more about the errors and how to fix them when using SQL Server as database in your application.

SQL Server Error Messages 9001 to 10000

ErrorCodeSeverityErrorMessage
900121The log for database ‘%.*ls’ is not available. Check the operating system error log for related error messages. Resolve any errors and restart the database.
900217The transaction log for database ‘%ls’ is full due to ‘%ls’.
900320The log scan number %S_LSN passed to log scan in database ‘%.*ls’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
900421An error occurred while processing the log for database ‘%.*ls’.  If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log.
900516Invalid parameter passed to OpenRowset(DBLog, …).
900610Cannot shrink log file %d (%s) because total number of logical log files cannot be fewer than %d.
900710Cannot shrink log file %d (%s) because requested size (%dKB) is larger than the start of the last logical log file.
900810Cannot shrink log file %d (%s) because the logical log file located at the end of the file is in use.
900910Cannot shrink log file %d (%s) because of minimum log space required.
901014User does not have permission to query the virtual table, DBLog. Only members of the sysadmin fixed server role and the db_owner fixed database role have this permission
901114User does not have permission to query backup files with the virtual table DBLog. Only members of the sysadmin fixed server role has this permission
901210There have been %d misaligned log IOs which required falling back to synchronous IO.  The current IO is on file %ls.
901310The tail of the log for database %ls is being rewritten to match the new sector size of %d bytes.  %d bytes at offset %I64d in file %ls will be written.
901421An error occurred while processing the log for database ‘%ls’. The log block version %d is unsupported. This server supports log version %d to %d.
901524The log record at LSN %S_LSN is corrupted.
901621An error occurred while processing the log for database ‘%.*ls’. The log block could not be decrypted.
901710Database %ls has more than %d virtual log files which is excessive. Too many virtual log files can cause long startup and backup times. Consider shrinking the log and using a different growth increment to reduce the number of virtual log files.
901816The log for database ‘%ls’ does not allow user writes.
901921The virtual log file sequence 0x%08x at offset 0x%016I64x bytes in file ‘%ls’ is active and cannot be overwritten with sequence 0x%08x for database ‘%ls’.
902016The log for database ‘%ls’ failed to grow while shrink in progress. Please retry.
902116Cannot accept virtual log file sequence 0x%08x for database ‘%ls’ because file %d does not exist yet.
902214The log can not be initialized because the log files are not fully formatted.
902316The log for database ‘%ls’ cannot be shrunk until all secondaries have moved past the point where the log was added..
902417The log for database ‘%ls’ cannot be expanded to allow room for consolidating the tenant log.
902516The feature ‘%ls’ is not yet implemented for log consolidation.
902610Consolidated log IO failure (%ls) error %d in host database %ls for tenant %d, file %d, offset 0x%016I64x. See prior errors.
902716This DB option is not available for log consolidation host DB.
902816Host DB (%ls) for this log consolidation tenant DB (%ls) is not writable.
902920The PMM log for database ‘%.*ls’ is not valid. This error may indicate data corruption. Restore from backup if the problem results in a persistent failure during startup.
903016Primary log file ‘%.*ls’ cannot be created on a persistent main memory volume.
903116File ‘%.*ls’ cannot be created on a persistent main memory volume as there cannot be more than one persistent main memory log files.
903216PERSISTENT_LOG_BUFFER can only be turned off when the database is in single user mode.
903316The transaction in database ‘%ls’ has exceeded the max size of %I64u bytes.  See ‘http://aka.ms/sqldw_loglimit’ for assistance.
903416PERSISTENT_LOG_BUFFER option is already on in database ‘%ls’.
903516PERSISTENT_LOG_BUFFER can only be set on the DAX volume.
903610The source has PERSISTENT_LOG_BUFFER enabled, but the current device is not DAX volume. PERSISTENT_LOG_BUFFER has been set to OFF.
903721The file ‘%.*ls’ on remote block device cannot be initialized. Native error is 0x%08x.
903810The VLF %lu could not be registered with the Log Leasing Service with error 0x%08X.
903910Could not start lease for VLF %lu for consumer ID %ls with the Log Leasing Service with error 0x%08X.
904010Could not end lease for consumer ID %ls with the Log Leasing Service with error 0x%08X.
904116Could not retrieve backup uris for log backup query from the fabric property BackupUris.
904216The log file’s ‘Size’ and ‘FixedVlfSize’ fields specified are invalid. Review the sizing requirements for a fixed VLF log.
904516Could not initialize the components required to dump page log records.
904616Log record at LSN %S_LSN is not a page log record.
904721Async recovery thread has exited unexpectedly, shutting down xlog reader.
904810%s is selected for pmem flush operation.
904910An exception occurred during flush initialization, the default clflush is selected For pmem flush operation.
910021Possible index corruption detected. Run DBCC CHECKDB.
910116auto statistics internal
910416auto statistics internal
910516The provided statistics stream is corrupt.
910616Histogram support not allowed for input data type 0x%08x.
910716The name, ‘%.*ls’, is invalid. The suffix ‘_readonly_database_statistic’ is reserved. Select another name without using the reserved suffix.
910816This type of statistics is not supported to be incremental.
910916Invalid partition number %I64d specified for %S_MSG ‘%.*ls’, partition number can range from 1 to %d.
911016Creating incremental statistics failed. Please execute the statement again.
911116UPDATE STATISTICS ON PARTITIONS syntax is not supported for non-incremental statistics.
911216Incremental statistics are not supported in this version of SQL Server.
911310Warning: Creating and updating statistics will force FULL SCAN in this version of SQL Server. If persisting sample percent, persisted_sample_percent will be 100.
911416CREATE/UPDATE STATISTICS is not supported on the specified internal table.
911516CREATE/UPDATE STATISTICS failed. Please execute the statement again.
911616Streaming statistics encountered an error with table ‘%.*ls’.
911710Warning: Ignoring STREAMING_STATISTICS option as the underlying table doesn’t meet all the criteria for streaming statistics.
911816%.*ls was specified as part of the CREATE/UPDATE STATISTICS syntax without %.*ls. They must be used together.
911916The table name ‘%.*ls’ exceeds the maximum length of 128 characters for the option %.*ls.
912016The statistics name ‘%.*ls’ is corrupt and must be dropped. If it is an index stats, the index must be rebuilt.
920110%d active query notification subscription(s) in database ‘%.*ls’ owned by security identification number ‘%.*ls’ were dropped.
920216The query notification subscription message is invalid.
920416The query notification subscription timeout is invalid. The allowed range is 1 through 2147483647.
920516User “%.*ls” does not have permission to request query notification subscriptions on database “%.*ls”.
920616The query notification subscription “%ld” cannot be deleted because it does not exist or it has already been fired.
920710The query notification dialog on conversation handle ‘%.*ls’ closed due to the following error: ‘%.*ls’.
920816Query notification subscription could not get dialog endpoint. Could not open service broker dialog for service name ‘%.*ls’ of broker instance ‘%.*ls’.
920916Query notification subscription could not begin dialog with service name ‘%.*ls’ of broker instance ‘%.*ls’.
921010Query notification delivery could not send message on dialog ‘%.*ls’. Delivery failed for notification ‘%.*ls’ because of the following error in service broker: ‘%.*ls’.
921110Failed to check for pending query notifications in database “%d” because of the following error when opening the database: ‘%.*ls’.
921310Query notification subscription could not access database with id %d. Could not open broker dialog for service name ‘%.*ls’ of broker instance ‘%.*ls’.
921416The query notification delivery failed to decode the error message from the Service Broker.
921516Query notification delivery failed to encode message. Delivery failed for notification ‘%.*ls’.
921610Failed to delete the expired query notification subscription “%d”.
921710Failed to drop the unused internal query notification table “%d” in database “%d”.
921816Query notifications reached the internal limit of the maximum number of objects.
921916The query notification subscriptions cleanup operation failed. See previous errors for details.
922010Query notification dialog on conversation handle ‘%.*ls’ closed due to an unknown service broker error.
922110Query notification delivery could not get dialog endpoint for dialog ‘%.*ls’. Delivery failed for notification ‘%.*ls’ because of the following error in service broker ‘%.*ls’.
922216Internal query notification table has an outdated schema and the table has been dropped. Query notification cleanup has not been performed for this table.
922310%d active query notification subscription(s) owned by security identification number ‘%.*ls’ were dropped.
922410Query notification delivery could not access database with id %d. Delivery failed for notification ‘%.*ls’.
922516The notification options identifier string has %d characters. The maximum allowed length is %d characters.
922616A string value within the notification options identifier is too long. String with prefix ‘%.*ls’ must be %d characters or less.
922716Unmatched quote in notification options identifier string.
922816Name expected in notification options identifier option.
922916Unknown option name ‘%.*ls’ present in notification options identifier. The following are valid option names: ‘Service’, ‘Broker Instance’, ‘Local Database’. Option names cannot be quoted.
923016Option ‘%ls’ was specified multiple times in the notification options identifier.
923116An equal (=) character was expected after the option name. Found ‘%.*ls’ instead.
923216A semicolon (;) must be use to separate options in a notification options identifier. String ‘%.*ls’ was found following an option.
923316The option ‘Service’ must be specified in the notification options identifier.
923416The options ‘Broker Instance’ and ‘Local Database’ were both specified in the notification options identifier.
923516Value missing for option ‘%ls’ in notification options identifier.
923616Database %.*ls is not a valid local database.
923716Database %.*ls is not a valid broker database.
923816Query notification subscriptions are not allowed under an active application role context. Consider re-issuing the request without activating the application role.
923916Internal query notifications error: The garbage collector corrected an inconsistency.
924010Service broker dialog ‘%.*ls’ could not be closed due to a broker error in database with id ‘%d’ because of the following error in service broker: ‘%.*ls’.
924116Service broker dialog ‘%.*ls’ could not be closed because the database with id ‘%d’ is not available. Consider closing the dialogs manually once the database is available again.
924210Query notification delivery could not get dialog endpoint for dialog ‘%.*ls’. Query notification delivery failed because of the following error in service broker: ‘%.*ls’. See the error log for additional information.
924310Query notification delivery could not send message on dialog ‘%.*ls’. Query notification delivery failed because of the following error in service broker: ‘%.*ls’. See the error log for additional information.
924416Query notification cleanup could not access metadata for database “%d”. Check whether the database is successfully restored and online.
924516During the last time interval %d query notification errors were suppressed.
924610Distributed Exchange moved %I64u rows and %I64u bytes.
930016%sIn this version of the server, the ‘fn:id()’ function only accepts an argument of type ‘IDREF *’.
930116%sIn this version of the server, ‘cast as <type>%s’ is not available. Please use the ‘cast as <type> ?’ syntax.
930216%sThe context item in which the ‘fn:id()’ function is used must be a node.
930316%sSyntax error near ‘%ls’, expected ‘%ls’.
930416%sThis version of the server only supports XQuery version ‘1.0’.
930516%sOnly type names followed by ‘?’ are supported in the target of ‘instance of’.
930616%sThe target of ‘replace value of’ cannot be a union type, found ‘%ls’.
930816%sThe argument of ‘%ls’ must be of a single numeric primitive type or ‘http://www.w3.org/2004/07/xpath-datatypes#untypedAtomic’. Found argument of type ‘%ls’.
930916%sThe target of ‘replace value of’ cannot be ‘http://www.w3.org/2001/XMLSchema#anySimpleType’, found ‘%ls’.
931016%sThe ‘with’ clause of ‘replace value of’ cannot contain constructed XML.
931116%sHeterogeneous sequences are not allowed in ‘%ls’, found ‘%ls’ and ‘%ls’.
931216%s’%ls’ is not supported on simple typed or ‘http://www.w3.org/2001/XMLSchema#anyType’ elements, found ‘%ls’.
931316%sThis version of the server does not support multiple expressions or expressions mixed with strings in an attribute constructor.
931416%sCannot implicitly atomize or apply ‘fn:data()’ to complex content elements, found type ‘%ls’ within inferred type ‘%ls’.
931516%sOnly constant expressions are supported for the name expression of computed element and attribute constructors.
931616%sCannot use ‘xmlns’ in the name expression of computed attribute constructor.
931716%sSyntax error near ‘%ls’, expected string literal.
931816%sSyntax error at source character ‘0x%02x’ near ‘%ls’, expected string literal.
931916%sStatic simple type validation: Invalid simple type value ‘%ls’.
932016%sThe result of applying the ‘parent’ axis on the document node is statically ’empty’.
932116%sThe result of applying ‘parent::%ls’ is statically ’empty’.
932216%sTwo consecutive ‘-‘ can only appear in a comment constructor if they are used to close the comment (‘–>’).
932316%sUsing ‘:’ in variable names is not supported in this version of the server.
932416%sFound ‘}’ without matching ‘{‘. If you want to use the characters ‘{‘ or ‘}’, you need to escape them as ‘{{‘ or ‘}}’ respectively.
932516%sComputed processing instruction constructors are not supported.
932616%sComputed comment constructors are not supported.
932716%sAll prolog entries need to end with ‘;’, found ‘%ls’.
932816%sType specification expected, found ‘%ls’.
933016%sOnly comparable types are allowed in ‘%ls’, found ‘%ls’.
933116%sSyntax error near ‘%ls’, expected ‘%ls’ or ‘%ls’.
933216%sSyntax error near ‘%ls’, expected ‘where’, ‘(stable) order by’ or ‘return’.
933316%s’//’ followed by ‘self’, ‘parent’ or ‘descendant-or-self’ axes is not supported when it encounters simple typed or ‘http://www.w3.org/2001/XMLSchema#anyType’ elements, found ‘%ls’.
933416%sThe ‘form’ attribute cannot be specified on a local attribute or element definition that has the ‘ref’ attribute. Location: ‘%ls’.
933516%sThe XQuery syntax ‘%ls’ is not supported.
933616%sThe XML Schema syntax ‘%ls’ is not supported.
933716%sThe XML Schema type ‘NOTATION’ is not supported.
933816%sThe value of a namespace declaration attribute must be a string literal. It cannot contain expressions.
933916%sThe ‘form’ attribute cannot be specified on a global attribute or element definition. Location: ‘%ls’.
934016%sExplicit import of the current target namespace is invalid. References to items in the current target namespace that have already been loaded in the schema collection will be resolved implicitly.
934116%sSyntax error near ‘%ls’, expected a step expression.
934216%sAn XML instance is only supported as the direct source of an insert using sql:column/sql:variable.
934316%sThe XML instance referred to by sql:column() and sql:variable() must be either untyped XML or must be typed with the same XML schema collection as the context XML instance on which the XML method is being applied to.
934416%sThe SQL type ‘%s’ is not supported with sql:column() and sql:variable().
940016XML parsing: line %d, character %d, unexpected end of input
940116XML parsing: line %d, character %d, unrecognized encoding
940216XML parsing: line %d, character %d, unable to switch the encoding
940316XML parsing: line %d, character %d, unrecognized input signature
941016XML parsing: line %d, character %d, whitespace expected
941116XML parsing: line %d, character %d, semicolon expected
941216XML parsing: line %d, character %d, ‘>’ expected
941316XML parsing: line %d, character %d, A string literal was expected
941416XML parsing: line %d, character %d, equal expected
941516XML parsing: line %d, character %d, well formed check: no ‘<‘ in attribute value
941616XML parsing: line %d, character %d, hexadecimal digit expected
941716XML parsing: line %d, character %d, decimal digit expected
941816XML parsing: line %d, character %d, ‘[‘ expected
941916XML parsing: line %d, character %d, ‘(‘ expected
942016XML parsing: line %d, character %d, illegal xml character
942116XML parsing: line %d, character %d, illegal name character
942216XML parsing: line %d, character %d, incorrect document syntax
942316XML parsing: line %d, character %d, incorrect CDATA section syntax
942416XML parsing: line %d, character %d, incorrect comment syntax
942516XML parsing: line %d, character %d, incorrect conditional section syntax
942616XML parsing: line %d, character %d, incorrect ATTLIST declaration syntax
942716XML parsing: line %d, character %d, incorrect DOCTYPE declaration syntax
942816XML parsing: line %d, character %d, incorrect ELEMENT declaration syntax
942916XML parsing: line %d, character %d, incorrect ENTITY declaration syntax
943016XML parsing: line %d, character %d, incorrect NOTATION declaration syntax
943116XML parsing: line %d, character %d, NDATA expected
943216XML parsing: line %d, character %d, PUBLIC expected
943316XML parsing: line %d, character %d, SYSTEM expected
943416XML parsing: line %d, character %d, name expected
943516XML parsing: line %d, character %d, one root element
943616XML parsing: line %d, character %d, end tag does not match start tag
943716XML parsing: line %d, character %d, duplicate attribute
943816XML parsing: line %d, character %d, text/xmldecl not at the beginning of input
943916XML parsing: line %d, character %d, namespaces beginning with “xml” are reserved
944016XML parsing: line %d, character %d, incorrect text declaration syntax
944116XML parsing: line %d, character %d, incorrect xml declaration syntax
944216XML parsing: line %d, character %d, incorrect encoding name syntax
944316XML parsing: line %d, character %d, incorrect public identifier syntax
944416XML parsing: line %d, character %d, well formed check: pes in internal subset
944516XML parsing: line %d, character %d, well formed check: pes between declarations
944616XML parsing: line %d, character %d, well formed check: no recursion
944716XML parsing: line %d, character %d, entity content not well formed
944816XML parsing: line %d, character %d, well formed check: undeclared entity
944916XML parsing: line %d, character %d, well formed check: parsed entity
945016XML parsing: line %d, character %d, well formed check: no external entity references
945116XML parsing: line %d, character %d, incorrect processing instruction syntax
945216XML parsing: line %d, character %d, incorrect system identifier syntax
945316XML parsing: line %d, character %d, ‘?’ expected
945416XML parsing: line %d, character %d, no ‘]]>’ in element content
945516XML parsing: line %d, character %d, illegal qualified name character
945616XML parsing: line %d, character %d, multiple colons in qualified name
945716XML parsing: line %d, character %d, colon in name
945816XML parsing: line %d, character %d, redeclared prefix
945916XML parsing: line %d, character %d, undeclared prefix
946016XML parsing: line %d, character %d, non default namespace with empty uri
946116XML %ls starting with ‘%.*ls’ is %d characters long, which exceeds the limit. Maximum allowed length is %d characters.
946216XML parsing: line %d, character %d, not all chunks of value have been read
946316XML parsing: line %d, character %d, xml:space has a non-legal value
946416XML parsing: line %d, character %d, XML namespace prefix ‘xml’ can only be associated with the URI http://www.w3.org/XML/1998/namespace. This URI cannot be used with other prefixes.
946516XML parsing: line %d, character %d, XML namespace prefix ‘xmlns’ is reserved for use by XML.
946616XML parsing: line %d, character %d, XML namespace xml namespace URI (http://www.w3.org/XML/1998/namespace) must be assigned only to prefix ‘xml’.
946716XML parsing: line %d, character %d, xmlns namespace URI (http://www.w3.org/2000/xmlns/) is reserved and must not be used.
948016XML parsing: line %d, character %d, unsupported xml
950016The data type ‘%.*ls’ used in the VALUE method is invalid.
950116XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable.
950216The string literal provided for the argument %d of the ‘%.*ls’ method must not exceed %d bytes.
950316Errors and/or warnings occurred when processing the XQuery statement for XML data type method ‘%.*ls’. See previous error messages for more details.
950416Errors 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.
950616The XMLDT method ‘%.*ls’ can only be invoked on columns of type xml.
950716The XML data type method on a remote column used in this query can not be executed either locally or remotely. Please rewrite your query.
950816The reference parameter given to XMLDT method ‘%.*ls’ was generated from a different XML instance than the one it is being applied to.
950916XMLUNNEST method requires typed xml column with single global element
951016Functionality not yet implemented: XMLNODEREFS cannot use references exposed by views.
951216Xml data type is not supported as a parameter to remote calls.
951316Error processing XML data type method ‘%.*ls’. The following SET options required by XML data type methods are not set: ‘%.*ls’.
951416Xml data type is not supported in distributed queries. Remote object ‘%.*ls’ has xml column(s).
951516An XML schema has been altered or dropped, and the query plan is no longer valid. Please rerun the query batch.
951616XQuery: 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.
951716XQuery: 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.
951816XQuery: 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.
951916XQuery: 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.
952016XQuery: ‘%.*ls’ referenced by sql:variable() is not a valid system function name.
952116Error processing XML data type. The XML data type instance contains a negative xs:date or xs:dateTime value.
952216The XQuery modify method is not allowed on sparse column sets.
952316Cannot 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 the column set.
952416The XML content provided does not conform to the required XML format for sparse column sets.
952516The 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.
952616In 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.
952716In 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.
952816In 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.
952916In 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 (char, varchar, nchar, nvarchar), or if the sparse column is of data type sql_variant and the value of the xsi:type attribute is “Char”, “VarChar”, “NChar”, or “NVarChar”.
953016In 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.
953116In the XML content that is supplied for the column set column ‘%.*ls’, the ‘%.*ls’ attribute value on the element ‘%.*ls’ is not valid.
953216In 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’.
953316In 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.
953416In 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 CLR types.
953516For untyped XML it is not allowed to specify MAXLENGTH or SINGLETON option if XSD type is not already specified for path ‘%.*ls’ of selective XML index ‘%.*ls’.
953616It is not allowed to specify REMOVE ‘%.*ls’ more than once for the same pathname in alter statement for selective XML index ‘%.*ls’.
953716Two paths indexed with selective XML index ‘%.*ls’ on table ‘%.*ls’ would have same path name with new collation.
953816Paths with same path expression indexed with selective XML index ‘%.*ls’ should have SINGLETON option either specified for all of them or for none of them.
953916Selective XML Index feature is not supported for the current database version
960116Cannot relate to %S_MSG %.*ls because it is %S_MSG.
960216Failed to start a system task with error code %d, state %d.
960510Conversation Priorities analyzed: %d.
960616The conversation priority with ID %d has been dropped.
960716The conversation priority with ID %d is referencing the missing service with ID %d.
960816The conversation priority with ID %d is referencing the missing service contract with ID %d.
960916The %S_MSG name ‘%.*ls’ contains more than the maximum number of prefixes. The maximum is %d.
961016The service ‘%.*ls’ in the FROM SERVICE clause must match the service ‘%.*ls’ referenced by %s = ‘%.*ls’.
961116Cannot find the specified user ‘%.*ls’.
961316The queue ‘%.*ls’ cannot be activated because the activation user is not specified.
961416The queue ‘%.*ls’ cannot be activated because the activation stored procedure is either not specified or is invalid.
961516A 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.
961616A 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.
961716The service queue “%.*ls” is currently disabled.
961816The message cannot be sent because the service queue ‘%.*ls’ associated with the dialog is currently disabled and retention is on.
961916Failed to create remote service binding ‘%.*ls’. A remote service binding for service ‘%.*ls’ already exists.
962016The activation stored procedure ‘%.*ls’ is invalid. Functions are not allowed.
962116An error occurred while processing a message in the Service Broker and Database Mirroring transport: error %i, state %i.
962216The crypto provider context is not initialized.
962316The key passed in for this operation is in the wrong state.
962416The key size is unacceptable for this key object.
962516The key buffer size is inconsistent with the key modulus size.
962616An 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 operating system error log for information pointing to possible hardware problems.
962716The hash buffer size is not correct for initializing the hash object.
962816The encryption/decryption data buffer size is not 8 byte aligned.
962916The decrypted signature size is wrong.
963016The signature did not verify the internal hash.
963116The salt size is unacceptable for this key object.
963216The salt buffer size is too small.
963316The passed in name is too long.
963416Service 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.
963516The certificate is not valid at this point in time.
963616The requested object was not found.
963716The passed in serialized object is incorrectly encoded.
963816The cer or pvk file size is too large.
963916A password was supplied and the pvk file is not encrypted.
964016The operation encountered an OS error.
964116A cryptographic operation failed. This error indicates a serious problem with SQL Server. Check the SQL Server error log and the operating system error log for further information.
964216An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: %i, State: %i. (Near endpoint role: %S_MSG, far endpoint address: ‘%.*hs’)
964316An error occurred in the Service Broker/Database Mirroring transport manager: Error: %i, State: %i.
964416An error occurred in the service broker message dispatcher. Error: %i, State: %i.
964516An error occurred in the service broker manager, Error: %i, State: %i.
964616An error occurred in the timer event cache. Error %i, state %i.
964716Received 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.
964820The 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.
964916A security (SSPI) error occurred when connecting to another service broker: ‘%.*ls’. Check the operating system error log for more information.
965016A system cryptographic call failed during a Service Broker or Database Mirroring operation: system error ‘%ls’.
965116The system call failed during a Service Broker or Database Mirroring operation. System error: ‘%ls’.
965216Service Broker failed to retrieve the session key for encrypting a message.
965316The signature of activation stored procedure ‘%.*ls’ is invalid. Parameters are not allowed.
965416Attempting to use database and it doesn’t exist.
965516The transmission queue table structure in database is inconsistent.  Possible database corruption.
965616An error occurred in the service broker multicast manager, Error: %i, State: %i.
965723The 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 operating system error log for information on possible hardware problems. Restart SQL Server to rebuild tempdb.
965816Cannot access the transmission queue table in database.
965916The %s of route ‘%.*ls’ cannot be empty.
966016The %s of route ‘%.*ls’ must be less than %d characters long.
966116The SERVICE_NAME and BROKER_INSTANCE of route “%.*ls” must be specified when using mirroring.
966216Cannot specify BROKER_INSTANCE without SERVICE_NAME in route “%.*ls”.
966316The system object cannot be modified.
966610The %S_MSG endpoint is in disabled or stopped state.
966710Services analyzed: %d.
966810Service Queues analyzed: %d.
966910Conversation Endpoints analyzed: %d.
967010Remote Service Bindings analyzed: %d.
967116Messages with conversation ID ‘%ls’ have been removed from the transmission queue.
967216Messages with conversation handle ‘%ls’ and conversation group ‘%ls’ have been removed from the queue with ID %d.
967316Activation has been disabled on the queue with ID %d.
967410Conversation Groups analyzed: %d.
967510Message Types analyzed: %d.
967610Service Contracts analyzed: %d.
967716The service contract with ID %d is referencing the missing message type with ID %d.
967816The service with ID %d is referencing the missing service contract with ID %d.
967916The service with ID %d is referencing the missing service queue with ID %d.
968016The conversation endpoint ‘%ls’ is referencing the missing conversation group ‘%ls’.
968116The conversation endpoint with ID ‘%ls’ and is_initiator: %d is referencing the missing service contract with ID %d.
968216The conversation endpoint with ID ‘%ls’ and is_initiator: %d is referencing the missing service with ID %d.
968316The conversation group ‘%ls’ is referencing the missing service with ID %d.
968416The service with ID %d has been dropped.
968516The service contract with ID %d has been dropped.
968616The conversation endpoint with handle ‘%ls’ has been dropped.
968716The conversation group ‘%ls’ has been dropped.
968810Service Broker manager has started.
968910Service Broker manager has shut down.
969010The %S_MSG endpoint is now listening for connections.
969110The %S_MSG endpoint has stopped listening for connections.
969216The %S_MSG endpoint cannot listen on port %d because it is in use by another process.
969316The %S_MSG endpoint cannot listen for connections due to the following error: ‘%.*ls’.
969416Could not start Service Broker manager. Check the SQL Server error log and the operating system error log for additional error messages.
969516Could 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.
969616Cannot 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.
969710Could 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.
969816Cannot start Service Broker security manager. This message is a symptom of another problem. Check the SQL Server error log and the operating system error log for additional messages, and address the underlying problem.
969916Could not allocate memory for extra Service Broker tasks while adding CPUs.
970116Cannot start Service Broker activation manager. This message is a symptom of another problem. Check the SQL Server error log and the operating system error log for additional messages and address the underlying problem.
970416This message could not be delivered because it failed XML validation. This failure occurred while the message was being delivered to the target service.
970516The messages in the queue with ID %d are referencing the invalid conversation handle ‘%ls’.
970616The stored procedure with ID %d is invalid but is referenced by the queue with ID %d.
970716The activation user with ID %d is invalid but is referenced by queue with ID %d.
970816The messages in the queue with ID %d are referencing the invalid conversation group ‘%ls’.
970916The messages in the queue with ID %d are referencing the invalid message type with ID %d.
971016The conversation endpoint with ID ‘%ls’ and is_initiator: %d is referencing the invalid conversation group ‘%ls’.
971116The transmission queue is referencing the invalid conversation ID ‘%ls’.
971216The remote service binding with ID %d is referencing the invalid service contract with ID %d.
971316The message type with ID %d is referencing the invalid XML schema collection ID %d.
971516The conversation endpoint with conversation handle ‘%ls’ is in an inconsistent state. Check the SQL Server error logs and the operating system error log for information on possible hardware problems. To recover the database, restore the database from a clean backup. If no clean backup is available, consider running DBCC CHECKDB. Note that DBCC CHECKDB may remove data.
971616The conversation group ‘%ls’ reports references to %d conversation handle(s), but actually references %d.
971716Cannot enable stored procedure activation on queue ‘%.*ls’. Event notification for queue_activation is already configured on this queue.
971816Cannot create event notification for queue_activation on queue “%.*ls”. Stored procedure activation is already configured on this queue.
971916The database for this conversation endpoint is attached or restored.
972016The database for the remote conversation endpoint is attached or restored.
972110Service 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.
972210Connection attempt to destination ‘%.*ls’ failed. %.*ls
972310The database “%i” will not be started as the broker due to duplication in the broker instance ID.
972410The activated proc ‘%ls’ running on queue ‘%ls’ output the following:  ‘%.*ls’
972516The invalid schema has been dropped from the message type with ID %d.
972616The remote service binding with ID %d has been dropped.
972716Dialog 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.
972816Cannot 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.
972910There is no cluster proxy route for the URI ‘%.*ls’.
973016Cannot 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.
973116Dialog 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.
973210Error during startup, shutdown or update of cluster proxy route manager.
973316There 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.
973416The length of the private key for the security certificate bound to database principal (Id: %i) is incompatible with the operating system cryptographic service provider. The key length must be a multiple of 64 bytes.
973516The length of the public key for the security certificate bound to database principal (Id: %i) is incompatible with the operating system cryptographic service provider. The key length must be a multiple of 64 bytes.
973616An error occurred in dialog transmission: Error: %i, State: %i. %.*ls
973716The 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.
973816Cannot 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 operating system error log for additional messages.
973916Message transmitter in service broker message dispatcher failed %d times
974016Cannot 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 messages, and address this underlying problem.
974110The %S_MSG ‘%.*ls’ was dropped on upgrade because it referenced a system contract that was dropped.
974216The activation stored procedure ‘%.*ls’ is invalid. Temporary procedures may not be configured for activation.
974316The %s of route “%.*ls” must be an address when using mirroring.
974416The %s of route “%.*ls” is not a valid address.
974516The ADDRESS of route ‘%.*ls’ cannot be ‘TRANSPORT’ when SERVICE_NAME is specified.
974616The LIFETIME of route ‘%.*ls’ must be in the range %d to %d.
974716The ADDRESS and MIRROR_ADDRESS of route ‘%.*ls’ cannot be the same.
974810The %S_MSG protocol transport is not available.
974910Target queue is busy; message(s) queued for delivery.
975010No 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.
975110Authentication failed with error: ‘%.*ls’.
975210%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’.
975310The target service broker is unreachable.
975410Connection attempt failed with error: ‘%.*ls’.
975510An error occurred while receiving data: ‘%.*ls’.
975610An internal exception occurred while connecting to an adjacent broker: Error: %i, State: %i. %.*ls
975710Service Broker/Database Mirroring network protocol error occurred.
975810Login protocol negotiation error occurred.
975910An error occurred while sending data: ‘%.*ls’.
976010The connection has been idle for over %d seconds.
976116The Broker Configuration conversation on dialog handle ‘%s’ closed due to an error. To troubleshoot this problem, investigate the error: ‘%.*ls’.
976210An error occurred while looking up the public key certificate associated with this SQL Server instance: No certificate was found.
976310An 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.
976410An error occurred while looking up the public key certificate associated with this SQL Server instance: The certificate found is too large.
976510An error occurred while looking up the public key certificate associated with this SQL Server instance: The certificate found has no associated private key.
976610An unknown internal error (%d) occurred while looking up the public key certificate associated with this SQL Server instance.
976716The 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 certificate ACTIVE FOR BEGIN_DIALOG.
976816A 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.
976910Insufficient memory prevented the Service Broker/Database Mirroring Transport Manager from starting.
977010Locating routes and security information via the Broker Configuration Service.
977110The service broker manager is disabled in single-user mode.
977216The Service Broker in database “%.*ls” cannot be enabled because there is already an enabled Service Broker with the same ID.
977310The Service Broker in database “%d” is disabled because there is already an enabled Service Broker with the same ID.
977410Cannot create a new Service Broker in the attached read-only database “%.*ls”. The Service Broker will be disabled.
977516Cannot create a new Service Broker in read-only database “%.*ls”.
977616Cannot 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).
977710The 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).
977816Cannot create a new Service Broker in a mirrored database “%.*ls”.
977910Service 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.
978010The service broker manager is initializing.
978110The service broker manager is shutting down.
978210An internal exception occurred while dispatching a message: Error: %i, State: %i. %.*ls
978310DNS lookup failed with error: ‘%.*ls’.
978410Service 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.
978510Invalid address specified: ‘%.*ls’.
978610Cannot retrieve user name from security context. Error: ‘%.*ls’. State: %hu.
978710An error occurred while processing broker mirroring routes. Error: %i. State: %i.
978810Unable to route the incoming message. The system database msdb containing routing information is not available.
978910Unable to route the incoming message. The system database msdb containing routing information is not available. The broker is disabled in msdb.
979010Unable to route the incoming message. The system database msdb containing routing information is in SINGLE USER mode.
979110The broker is disabled in the sender’s database.
979210Could not forward the message because forwarding is disabled in this SQL Server instance.
979310The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied.
979410The broker mirroring manager has not fully initialized.
979510Could not find the target broker in the local SQL Server instance.
979610The target service name matched a LOCAL route, but there is no service by that name in the local SQL Server instance.
979710Classification has been delayed because the routing information is currently being updated.
979816The message could not be delivered because it could not be classified. Enable broker message classification trace to see the reason for the failure.
979910The connection was closed by the remote end, or an error occurred while receiving data: ‘%.*ls’
980116Error converting %.*ls to %ls. The result would be truncated.
980216The locale identifier (LCID) %d is not supported by SQL Server.
980316Invalid data for type “%ls”.
980416Column or parameter #%d: Invalid fractional second precision %d specified for %ls data type. The maximum fractional second precision is %d.
980510Warning: converting %ls to %ls caused a loss of information.
980616The datepart %.*ls is not supported by date function %.*ls.
980716The input character string does not follow style %d, either change the input character string or use a different style.
980816This 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.
980916The style %d is not supported for conversions from %s to %s.
981016The datepart %.*ls is not supported by date function %.*ls for data type %s.
981116The system timezone information could not be retrieved.
981216The timezone provided to builtin function %.*ls is invalid.
981316The timezone provided to builtin function %.*ls would cause the datetimeoffset to overflow the range of valid date range in either UTC or local time.
981416The 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).
981516Waitfor delay and waitfor time cannot be of type %s.
981616The number of columns in the column set exceeds 2048. Reduce the number of columns that are referenced in the column set.
981716The 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.
981816The culture parameter ‘%.*ls’ provided in the function call is not supported.
981916Error converting string value ‘%.*ls’ into data type %ls using culture ‘%.*ls’.
982016The time zone parameter ‘%.*ls’ provided to AT TIME ZONE clause is invalid.
982116Internal error occurred during time zone conversion.
982216Internal error occurred during time zone data access.
982316COMPRESS builtin failed.
982416Not enough memory for COMPRESS builtin to execute.
982516DECOMPRESS builtin failed.
982616Uncompressed or corrupted data passed as argument to DECOMPRESS builtin.
982716Not enough memory for DECOMPRESS builtin to execute.
982816The second and third arguments of the TRANSLATE built-in function must contain an equal number of characters.
982916STRING_AGG aggregation result exceeded the limit of 8000 bytes. Use LOB types to avoid result truncation.
983016%ls cannot be less than zero.\nParameter name: %ls.
983116%ls cannot be larger than length of string.\nParameter name: %ls.
983216Index and length must refer to a location within the string.\nParameter name: %ls.
983316Invalid data for %ls-encoded characters
990116Full-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.
990210Full-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 indexing for multiple catalogs.
990310The 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 frequently, consult SQL Server Books Online for troubleshooting assistance. This is an informational message only. No user action is required.
990410The 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 message only. No user action is required.
990510Informational: Full-text indexer requested status change for catalog ‘%ls’ (‘%d’) in database ‘%ls’ (‘%d’). New Status: %ls, Reason: %ls (%ls).
990610The 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.
990710Error: Total number of items in full-text catalog ID ‘%d’ in database ID ‘%d’ exceeds the supported limit. See Books Online for troubleshooting assistance.
990810Changing 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.
990910Warning: Failed to change the status to %ls for full-text catalog ‘%ls’ (%d) in database ‘%ls’ (%d). Error: %ls.
991010Warning: 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.
991110Informational: Full-text %ls population initialized for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’). Population sub-tasks: %d.
991210Error: 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.
991310Informational: 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.
991416Error: 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.
991510Reinitialized 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 required.
991610Error: 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.
991717An internal error occurred in full-text docid mapper.
991810Warning: Full-text catalog ‘%ls’ uses FAT volume. Security and differential backup are not supported for the catalog.
991916Fulltext DDL command failed because SQL Server was started in single user mode.
992010Warning: Failed to get MSFTESQL indexer interface for full-text catalog ‘%ls’ (‘%d’) in database ‘%ls’ (‘%d’). Error: %ls.
992116During upgrade fatal error 0x%x encountered in CoCreateGuid. Failed to resolve full-text catalog file name for ‘%ls’.
992210Warning: 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.
992310Warning: 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.
992416Rebuild full-text catalog ‘%ls’ failed: Catalog header file is read-only.
992516Rebuild full-text catalog ‘%ls’ failed: Full-text catalog is read-only.
992610Informational: MS Search stop limit reached. The full-text query may have returned fewer rows than it should.
992710Informational: The full-text search condition contained noise word(s).
992816Computed column ‘%.*ls’ cannot be used for full-text search because it is nondeterministic or imprecise nonpersisted computed column.
992916Computed 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.
993010Null document type provided. Row will not be full-text indexed.
993110Document type exceeds the maximum permitted length. Row will not be full-text indexed.
993210Document type value is malformed. Row will not be full-text indexed.
993310Internal 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.
993410Row was not found. It was deleted or updated while indexing was in progress.
993510Warning: 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.
993610Informational: No full-text supported languages found.
993716Too many full-text columns or the full-text query is too complex to be executed.
993816Cannot find the specified user or role ‘%.*ls’.
993916Current user or role ‘%.*ls’ does not have the required permission to set the owner.
994010Error: 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.
994110Informational: 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
994210Informational: Full-text %ls population for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’) was cancelled by  user.
994310Informational: 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.
994410Informational: 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.
994510Error: All Full-text populations in progress, for catalog ‘%ls’ (‘%d’) in database ‘%ls’ (‘%d’) were terminated due to error. Error: 0x%x.
994710Warning: Identity of full-text catalog in directory ‘%ls’ does not match database ‘%.*ls’. The full-text catalog cannot be attached.
994810Warning: 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.
994910Warning: 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.
995010Informational: 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 failure and start population from scratch.
995110Warning: 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.
995210Informational: 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.
995316The path ‘%.*ls’ has invalid attributes. It needs to be a directory. It must not be hidden, read-only, or on a removable drive.
995416SQL Server failed to communicate with filter daemon launch service  (OS error: %ls). Full-Text filter daemon process failed to start. Full-text search functionality will not be available.
995516SQL Server failed to create named pipe ‘%ls’ to communicate with the full-text filter daemon (OS 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 (SID) lookup for the filter daemon account group failed. To resolve this error, terminate any running full-text filter daemon processes, and if necessary reconfigure the full-text daemon launcher service account.
995916Cannot perform requested task because full-text memory manager is not initialized.
996016View ‘%.*ls’ is not an indexed view. Full-text index is not allowed to be created on it.
996116Logical name, size, maxsize, filegrowth, and offline properties of full-text catalog cannot be modified.
996216Failed to move full-text catalog from ‘%ls’ to ‘%ls’. OS error ‘%ls’.
996310Inconsistent accent sensitivity of full-text catalog is detected. Full-text catalog for catalog ID ‘%d’, database ID ‘%d’ is reset.
996416Failed to finish full-text operation. Filegroup ‘%.*ls’ is empty, read-only, or not online.
996516NULL or Invalid type of value specified for ‘%ls’ parameter.
996616Cannot use full-text search in master, tempdb, or model database.
996710A default full-text catalog does not exist in database ‘%.*ls’ or user does not have permission to perform this action.
996810Warning: 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.
996910Warning: 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.
997016Couldn’t complete full-text operation because full-text key for table or indexed view ‘%.*ls’ is offline.
997110Warning: 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 indexed.
997216Database 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.
997310Informational: 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.
997410Warning: 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.
997510Warning: Only paused full population can be resumed. The command is ignored.
997710Warning: 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.
997810Warning: 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.
997910Warning: 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.
998016Variable parameters can not be passed to fulltext predicates: contains, freetext and functions: containstable, freetexttable applied to remote table.
998216Cannot use full-text search in user instance.
998316The value ‘%ls’ for the full-text component ‘%ls’ is longer than the maximum permitted (%d characters). Please reduce the length of the value.
998410Informational: Full-text %ls population paused for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’).
998516There is not enough memory to generate a search property list cache. Rerun your full-text indexing statement when more resources are available.
998616A 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’).
998715The max gap argument in NEAR clause must be either the word MAX or an integer greater than or equal to 0.
998815The number of query terms in NEAR clause must be less than or equal to 64.
998916Cannot use full-text search in this instance.
999816The 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.
999916The column ‘%.*ls’ in the table ‘%.*ls’ cannot be used for full-text search because it is a sparse column set.
1000016Unknown provider error.