SQL Server Error Messages 7001 to 8000

In this post, we’ll list out the SQL Server Error Messages from the error codes 7001 to 8000 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 7001 to 8000

ErrorCodeSeverityErrorMessage
700116OPENXML flags parameter must be of data type int.
700216OPENXML XPath must be of a string data type, such as nvarchar.
700316Only one OPENXML column can be of type %ls.
700416OPENXML does not support retrieving schema from remote tables, as in ‘%.*ls’.
700516OPENXML requires a metaproperty namespace to be declared if ‘mp’ is used for another namespace in sp_xml_preparedocument.
700616OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement.
700716OPENXML encountered unknown metaproperty ‘%.*ls’.
700816The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.
700916OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument.
710116You need an active user transaction in order to use text pointers for a table with the option “text in row” set to ON.
710220Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.
710416Offset or size of data type is not valid. Data type must be of type int or smallint.
710522The Database ID %d, Page %S_PGID, slot %d for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
710616Internal error: An attempt was made to update a LOB data type using a read-only text pointer.
710716You can have only 1,024 in-row text pointers in one transaction
710822Database ID %d, page %S_PGID, slot %d, link number %d is invalid. Run DBCC CHECKTABLE.
711616Offset %d is not in the range of available LOB data.
711716Error reading large object (LOB) data from the tabular data stream (TDS).
711816Only complete replacement is supported when assigning a large object (LOB) to itself.
711916Attempting to grow LOB beyond maximum allowed size of %I64d bytes.
712216Invalid text, ntext, or image pointer type. Must be binary(16).
712316Invalid text, ntext, or image pointer value %hs.
712416The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
712516The text, ntext, or image pointer value conflicts with the column name specified.
713316NULL textptr (text, ntext, or image pointer) passed to %ls function.
713416LOB Locator is not supported as text pointer when using UPDATETEXT/WRITETEXT to update/write a text column.
713516Deletion length %ld is not in the range of available text, ntext, or image data.
713716%s is not allowed because the column is being processed by a concurrent snapshot or is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS) or tracked by Change Data Capture.
713816The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS) or tracked by Change Data Capture.
713916Length of LOB data (%I64d) to be replicated exceeds configured maximum %ld. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.
714016Cannot create additional orphans with the stored procedure sp_createorphan. Free up some of the orphan handles that you have created by inserting or deleting them.
714116Must create orphaned text inside a user transaction.
714316Invalid locator de-referenced.
714416A text/ntext/image column referenced by a persisted or indexed computed column cannot be updated
715116Insufficient buffer space to perform write operation.
715216READEXT, WRITETEXT, and UPDATETEXT statements cannot be used on tables that are referenced by an enabled security policy.
720117Could not execute procedure on remote server ‘%.*ls’ because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.
720211Could not find server ‘%.*ls’ in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
721216Could not execute procedure ‘%.*ls’ on remote server ‘%.*ls’.
721320The attempt by the provider to pass remote stored procedure parameters to remote server ‘%.*ls’  failed. Verify that the number of parameters, the order, and the values passed are correct.
721416Remote procedure time out of %d seconds exceeded. Remote procedure ‘%.*ls’ is canceled.
721516Could not execute statement on remote server ‘%.*ls’.
722116Could not relay results of procedure ‘%.*ls’ from remote server ‘%.*ls’.
722216Only a SQL Server provider is allowed on this instance.
722310Warning: Enabling ‘remote proc trans’ is not supported on this instance.  Defaulting to disabled.
722416Enabling ‘remote proc trans’ is not supported on this instance.
730116Cannot obtain the required interface (“%ls”) from OLE DB provider “%ls” for linked server “%ls”.
730216Cannot create an instance of OLE DB provider “%ls” for linked server “%ls”.
730316Cannot initialize the data source object of OLE DB provider “%ls” for linked server “%ls”.
730416Cannot connect using OLE DB provider “%ls” to linked server “%ls”. Verify the connection parameters or login credentials associated with this linked server.
730516Cannot create a statement object using OLE DB provider “%ls” for linked server “%ls”.
730616Cannot open the table “%ls” from OLE DB provider “%ls” for linked server “%ls”. %ls
730716Cannot obtain the data source of a session from OLE DB provider “%ls” for linked server “%ls”. This action must be supported by the provider.
730816OLE DB provider ‘%ls’ cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
731016Cannot obtain the set of schema rowsets supported by OLE DB provider “%ls” for linked server “%ls”. The provider supports the interface, but returns a failure code when it is used.
731116Cannot obtain the schema rowset “%ls” for OLE DB provider “%ls” for linked server “%ls”. The provider supports the interface, but returns a failure code when it is used.
731216Invalid use of schema or catalog for OLE DB provider “%ls” for linked server “%ls”. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.
731316An invalid schema or catalog was specified for the provider “%ls” for linked server “%ls”.
731416The OLE DB provider “%ls” for linked server “%ls” does not contain the table “%ls”. The table either does not exist or the current user does not have permissions on that table.
731516The OLE DB provider “%ls” for linked server “%ls” contains multiple tables that match the name “%ls”.
731616Cannot use qualified table names (schema or catalog) with the OLE DB provider “%ls” for linked server “%ls” because it does not implement required functionality.
731716The OLE DB provider “%ls” for linked server “%ls” returned an invalid schema definition.
731816The OLE DB provider “%ls” for linked server “%ls” returned an invalid column definition for table “%ls”.
731916The OLE DB provider “%ls” for linked server “%ls” returned a “%ls” index “%ls” with the incorrect bookmark ordinal %d.
732016Cannot execute the query “%ls” against OLE DB provider “%ls” for linked server “%ls”. %ls
732116An error occurred while preparing the query “%ls” for execution against OLE DB provider “%ls” for linked server “%ls”. %ls
732216A failure occurred while giving parameter information to OLE DB provider “%ls” for linked server “%ls”.
732316An error occurred while submitting the query text to OLE DB provider “%ls” for linked server “%ls”.
732416A failure occurred while setting parameter properties with OLE DB provider “%ls” for linked server “%ls”.
732516Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object ‘%ls’.
732616An error occurred while retrieving the query text from OLE DB provider “%ls” for linked server “%ls”.
732716A failure occurred while retrieving parameter information to OLE DB provider “%ls” for linked server “%ls”.
733016Cannot fetch a row from OLE DB provider “%ls” for linked server “%ls”.
733116Rows from OLE DB provider “%ls” for linked server “%ls” cannot be released.
733216Cannot rescan the result set from OLE DB provider “%ls” for linked server “%ls”. %ls
733316Cannot fetch a row using a bookmark from OLE DB provider “%ls” for linked server “%ls”.
733916OLE DB provider ‘%ls’ for linked server ‘%ls’ returned invalid data for column ‘%ls.%ls’.
734016Cannot create a column accessor for OLE DB provider “%ls” for linked server “%ls”.
734116Cannot get the current row value of column “%ls.%ls” from OLE DB provider “%ls” for linked server “%ls”. %ls
734216An unexpected NULL value was returned for column “%ls.%ls” from OLE DB provider “%ls” for linked server “%ls”. This column cannot be NULL.
734316The OLE DB provider “%ls” for linked server “%ls” could not %ls table “%ls”. %ls
734416The OLE DB provider “%ls” for linked server “%ls” could not %ls table “%ls” because of column “%ls”. %ls
734516The OLE DB provider “%ls” for linked server “%ls” could not delete from table “%ls”. %ls
734616Cannot get the data of the row from the OLE DB provider “%ls” for linked server “%ls”. %ls
734716OLE DB provider ‘%ls’ for linked server ‘%ls’ returned data that does not match expected data length for column ‘%ls.%ls’. The (maximum) expected data length is %ls, while the returned data length is %ls.
734816The OLE DB provider “%ls” for linked server “%ls” could not set the range for table “%ls”. %ls. For possible cause of this issue, see the extended error message.
734916The OLE DB provider “%ls” for linked server “%ls” could not set the range for table “%ls” because of column “%ls”. %ls
735016Cannot get the column information from OLE DB provider “%ls” for linked server “%ls”.
735116The OLE DB provider “%ls” for linked server “%ls” could not map ordinals for one or more columns of object “%ls”.
735216The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata. The object “%ls” was missing the expected column “%ls”.
735316The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
735416The OLE DB provider “%ls” for linked server “%ls” supplied invalid metadata for column “%ls”. %ls
735516The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata for a column. The name was changed at execution time.
735616The OLE DB provider “%ls” for linked server “%ls” supplied inconsistent metadata for a column. The column “%ls” (compile-time ordinal %ld) of object “%ls” was reported to have a “%ls” of %ld at compile time and %ld at run time.
735716Cannot process the object “%ls”. The OLE DB provider “%ls” for linked server “%ls” indicates that either the object has no columns or the current user does not have permissions on that object.
735816Cannot execute the query. The OLE DB provider “%ls” for linked server “%ls” did not provide an appropriate interface to access the text, ntext, or image column “%ls.%ls”.
735916The OLE DB provider “%ls” for linked server “%ls” reported a change in schema version between compile time (“%ls”) and run time (“%ls”) for table “%ls”.
736016Cannot get the length of a storage object from OLE DB provider “%ls” for linked server “%ls” for table “%ls”, column “%ls”.
736116Cannot read a storage object from OLE DB provider “%ls” for linked server “%ls”, for table “%ls”, column “%ls”.
736216The OLE DB provider “%ls” for linked server “%ls” reported different metadata at run time for table “%ls”, column “%ls”.
736516Cannot obtain optional metadata columns of columns rowset from OLE DB provider “%ls” for linked server “%ls”.
736616Cannot obtain columns rowset from OLE DB provider “%ls” for linked server “%ls”.
736716The OLE DB provider “%ls” for linked server “%ls” supports column level collation, but failed to provide the metadata column “%ls” at run time.
736816The OLE DB provider “%ls” for linked server “%ls” supports column level collation, but failed to provide collation data for column “%ls”.
736916The OLE DB provider ‘%ls’ for linked server ‘%ls’ provided invalid collation.  LCID = %08x, Compflags = %08x, SortOrder = ‘%.*ls’.
737016One or more properties could not be set on the query for OLE DB provider “%ls” for linked server “%ls”. %ls
737116The server option ‘collation name’ in linked server ‘%ls’ for OLE DB provider ‘%ls’ has collation id %08x which is not supported by SQL Server.
737216Cannot get properties from OLE DB provider “%ls” for linked server “%ls”.
737316Cannot set the initialization properties for OLE DB provider “%ls” for linked server “%ls”.
737416Cannot set the session properties for OLE DB provider “%ls” for linked server “%ls”.
737516Cannot open index “%ls” on table “%ls” from OLE DB provider “%ls” for linked server “%ls”. %ls
737616Could not enforce the remote join hint for this query.
737716Cannot specify an index hint for a remote data source.
738016Table-valued parameters are not allowed in remote calls between servers.
739016The requested operation could not be performed because OLE DB provider “%ls” for linked server “%ls” does not support the required transaction interface.
739116The operation could not be performed because OLE DB provider “%ls” for linked server “%ls” was unable to begin a distributed transaction.
739216Cannot start a transaction for OLE DB provider “%ls” for linked server “%ls”.
739316The OLE DB provider “%ls” for linked server “%ls” reported an error 0x%08X aborting the current transaction.
739416The OLE DB provider “%ls” for linked server “%ls” reported an error committing the current transaction.
739516Unable to start a nested transaction for OLE DB provider “%ls” for linked server “%ls”. A nested transaction was required because the XACT_ABORT option was set to OFF.
739616Varchar(max), nvarchar(max), varbinary(max) and large CLR type data types are not supported as return value or output parameter to remote queries.
739716Remote function returned varchar(max), nvarchar(max), varbinary(max) or large CLR type value which is not supported.
739816The OLE DB provider ‘%ls’ for linked server ‘%ls’ reported an error committing the current inserts.
739916The OLE DB provider “%ls” for linked server “%ls” reported an error. %ls
740116The OLE DB provider “%ls” returned invalid literal prefix/suffix string.
740316The OLE DB provider “%ls” has not been registered.
740416The server could not load DCOM.
740516Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
740916Could not start distributed query using integrated login because the user is logged in using SQL Server authentication. Provide remote server login user ID and password in the connection string.
741016Remote access is not allowed for impersonated security context.
741116Server ‘%.*ls’ is not configured for %ls.
741216OLE DB provider “%ls” for linked server “%ls” returned message “%ls”.
741316Could not connect to linked server ‘%ls’ (OLE DB Provider ‘%ls’). Enable delegation or use a remote SQL Server login for the current user.
741416Invalid number of parameters. Rowset ‘%ls’ expects %d parameter(s).
741516Ad hoc access to OLE DB provider ‘%ls’ has been denied. You must access this provider through a linked server.
741616Access to the remote server is denied because no login-mapping exists.
741716GROUP BY ALL is not supported in queries that access remote tables if there is also a WHERE clause in the query.
741816Text, image, or ntext column was too large to send to the remote data source due to the storage interface used by the provider.
741916Lazy schema validation error. Linked server schema version has changed. Re-run the query.
742016Remote access is not supported for transaction isolation level “%ls”.
742110Cannot fetch the rowset from OLE DB provider “%ls” for linked server “%ls”. %ls.
742216OLE DB provider “%ls” for linked server “%ls” returned an invalid index definition for table “%ls”.
742316The ‘%ls’ OLE DB provider for the ‘%ls’ linked server returned an invalid CLR type definition for the ‘%ls’ table.
742410OLE DB provider “%ls” for linked server “%ls” returned “%ls” with data type “%ls”, which should be type “%ls”.
742510OLE DB provider “%ls” for linked server “%ls” returned an incorrect value for “%ls”, which should be “%ls”.
742610OLE DB provider “%ls” for linked server “%ls” returned “%ls” without “%ls” being supported.
742710OLE DB provider “%ls” for linked server “%ls” returned “%ls” for “%ls” during statistics gathering.
742810OLE DB provider “%ls” for linked server “%ls” supported the schema lock interface, but returned “%ls” for “%ls”.
742910%hs SQL Server Remote Metadata Gather Time for Table %s.%s:%hs, CPU time = %lu ms,  elapsed time = %lu ms.
743016Out-of-process use of OLE DB provider “%ls” with SQL Server is not supported.
743116Unable to delete OLE DB parameter properties.
743216Heterogeneous queries and use of OLEDB providers are not supported in fiber mode.
743310OLE DB provider ‘%ls’ for linked server ‘%ls’ returned truncated data for column ‘%ls.%ls’. The actual data length is %ls and truncated data length is %ls.
743516The OLE DB provider “%ls” for linked server “%ls” returned unexpected NULL pointer for string column “%ls.%ls”.
743616The query processor could not produce a query plan because FORCESEEK or FORCESCAN hints on table or view ‘%.*ls’ cannot be used with remote data sources. Remove the hints and resubmit the query.
743716Linked servers cannot be used under impersonation without a mapping for the impersonated login.
743816The 32-bit OLE DB provider “%ls” cannot be loaded in-process on a 64-bit SQL Server.
743916Failed to read required information about %S_MSG pool %S_MSG.
744010Remote execution status: “%ls” .
760116Cannot use a CONTAINS or FREETEXT predicate on %S_MSG ‘%.*ls’ because it is not full-text indexed.
760417Full-text operation failed due to a time out.
760617Could not find full-text index for database ID %d, table or indexed view ID %d.
760717Search on full-text catalog ‘%ls’ for database ID %d, table or indexed view ID %d with search condition ‘%ls’ failed with unknown result (0x%x).
760816An unknown full-text failure (0x%x) occurred during “%hs”.
760917Full-Text Search is not installed, or a full-text component cannot be loaded.
761016Access is denied to “%.*ls”, or the path is invalid.
761316Cannot drop index ‘%.*ls’ because it enforces the full-text key for table or indexed view ‘%.*ls’.
761416Cannot alter or drop column ‘%.*ls’ because it is enabled for Full-Text Search.
761516A CONTAINS or FREETEXT predicate can only operate on one table or indexed view. Qualify the use of * with a table or indexed view name.
761616Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. The functionality to disable and enable full-text search for a database is deprecated. Please change your application.
761716Query does not reference the full-text indexed table or indexed view, or user does not have permission to perform this action.
761916The execution of a full-text query failed. “%ls”
762016The conversion to data type %ls failed for the full-text search key.
762116Invalid use of full-text predicate in the HAVING clause.
762217There is not sufficient disk space to complete this operation for the full-text catalog “%ls”.
762416Full-text catalog ‘%ls’ is in an unusable state. Drop and re-create this full-text catalog.
762516Full-text table or indexed view has more than one LCID among its full-text indexed columns.
762615The top_n_by_rank argument (‘%d’) must be greater than or equal to zero.
762716Cannot create the full-text catalog in the directory “%.*ls” for the clustered server. Only directories on a disk in the cluster group of the server can be used.
762917Cannot open or query the full-text default path registry key. The full-text default catalog path is invalid.
763015Syntax error near ‘%.*ls’ in the full-text search condition ‘%.*ls’.
763215The value of the Weight argument must be between 0.0 and 1.0.
763610Warning: Request to start a full-text index population on table or indexed view ‘%.*ls’ is ignored because a population is currently active for this table or indexed view.
763810Warning: Request to stop change tracking has deleted all changes tracked on table or indexed view ‘%ls’.
764010Warning: Request to stop tracking changes on table or indexed view ‘%.*ls’ will not stop population currently in progress on the table or indexed view.
764116Full-Text catalog ‘%ls’ does not exist in database ‘%.*ls’ or user does not have permission to perform this action.
764216A full-text catalog named ‘%ls’ already exists in this database. Use a different name.
764416Full-text crawl manager has not been initialized. Any crawl started before the crawl manager was fully initialized will need to be restarted. Please restart SQL Server and retry the command. You should also check the error log to fix any failures that might have caused the crawl manager to fail.
764516Null or empty full-text predicate.
764616Fulltext predicate references columns from two different tables or indexed views ‘%.*ls’ and ‘%.*ls’ which is not allowed.
764710Warning: Configuration of full-text catalog at ‘%ls’ could not be saved during detach database.
764810Warning: Failed to attach full-text catalog ‘%ls’.
764910Warning: Failed to dismount full-text catalog at ‘%ls’.
765010Warning: Failed to drop full-text catalog at ‘%ls’.
765110Warning: The ongoing population is necessary to ensure an up-to-date index. If needed, stop change tracking first, and then deactivate the full-text index population.
765216A full-text index for table or indexed view ‘%.*ls’ has already been created.
765316‘%ls’ is not a valid index to enforce a full-text search key. A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, does not have a filter, and has maximum size of %d bytes. Choose another index for the full-text key.
765416Unable to obtain the population status of the table or indexed view ‘%.*ls’.
765516TYPE COLUMN option must be specified with column of image or varbinary(max) type.
765616Full-text index for table or indexed view ‘%.*ls’ cannot be populated because the database is in single-user access mode.
765710Warning: Table or indexed view ‘%.*ls’ has full-text indexed columns that are of type image, text, or ntext. Full-text change tracking cannot track WRITETEXT or UPDATETEXT operations performed on these columns.
765816Table or indexed view ‘%.*ls’ does not have a full-text index or user does not have permission to perform this action.
765916Cannot activate full-text search for table or indexed view ‘%.*ls’ because no columns have been enabled for full-text search.
766016Full-text search must be activated on table or indexed view ‘%.*ls’ before this operation can be performed.
766110Warning: Full-text change tracking is currently enabled for table or indexed view ‘%.*ls’.
766210Warning: Full-text auto propagation is currently enabled for table or indexed view ‘%.*ls’.
766316Option ‘WITH NO POPULATION’ should not be used when change tracking is enabled.
766416Full-text change tracking must be started on table or indexed view ‘%.*ls’ before the changes can be flushed.
766516Full Crawl must be executed on table or indexed view ‘%.*ls’. Columns affecting the index have been added or dropped since the last index full population.
766616User does not have permission to perform this action.
766816Cannot drop full-text catalog ‘%ls’ because it contains a full-text index.
766910Warning: Full-text index for table or indexed view ‘%.*ls’ cannot be populated because the database is in single-user access mode. Change tracking is stopped for this table or indexed view.
767016Column ‘%.*ls’ cannot be used for full-text search because it is not a character-based, XML, image or varbinary(max) type column or it is encrypted.
767116Column ‘%.*ls’ cannot be used as full-text type column for image column. It must be a character-based column with a size less or equal than %d characters.
767216A full-text index cannot be created on the table or indexed view because duplicate column ‘%.*ls’ is specified.
767310Warning: Full-text change tracking is currently disabled for table or indexed view ‘%.*ls’.
767410Warning: The fulltext catalog ‘%.*ls’ is being dropped and is currently set as default.
767610Warning: Full-text auto propagation is on. Stop crawl request is ignored.
767716Column “%.*ls” is not full-text indexed.
767816The following string is not defined as a language alias in syslanguages: %.*ls.
767916Full-text index language of column “%.*ls” is not a language supported by full-text search.
768016Default full-text index language is not a language supported by full-text search.
768110Warning: Directory ‘%ls’ does not have a valid full-text catalog. Full-text catalog header file or attach state file either is missing or corrupted. The full-text catalog cannot be attached.
768210The component ‘%ls’ reported error while indexing. Component path ‘%ls’.
768316Errors were encountered during full-text index population for table or indexed view ‘%ls’, database ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’). Please see full-text crawl logs for details.
768410Error ‘%ls’ occurred 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’. Failed to index the row.
768510Error ‘%ls’ occurred 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’. Attempt will be made to reindex it.
768610Cannot use a CONTAINS, FREETEXT, CONTAINSTABLE or FREETEXTTABLE construct on table or indexed view ‘%.*ls’ because none of its columns are full-text indexed. Register at least one column for full-text search using ALTER FULLTEXT INDEX statement.
768916Execution of a full-text operation failed. ‘%ls’
769016Full-text operation failed because database is read only.
769116Access is denied to full-text log path. Full-text logging is disabled for database ‘%ls’, catalog ‘%ls’ (database ID ‘%d’, catalog ID ‘%d’).
769216Full-text catalog path ‘%.*ls’ exceeded %d character limit.
769316Full-text initialization failed to create a memory clerk.
769416Failed to pause catalog for backup. Backup was aborted.
769616Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed.
769710Warning: Full-text index on table or indexed view ‘%.*ls’ in database ‘%.*ls’ has been changed after full-text catalog files backup. A full population is required to bring full-text index to a consistent state.
769816GROUP BY ALL cannot be used in full text search queries.
769916TYPE COLUMN option is not allowed for column types other than image or varbinary(max).
770216Empty Partition function type-parameter-list is not allowed when defining a partition function.
770316Can not create RANGE partition function with multiple parameter types.
770416The type ‘%.*ls’ is not valid for this operation.
770516Could not implicitly convert range values type specified at ordinal %d to partition function parameter type.
770616Partition function ‘%ls’ is being used by one or more partition schemes.
770716The associated partition function ‘%ls’ generates more partitions than there are file groups mentioned in the scheme ‘%ls’.
770816Duplicate range boundary values are not allowed in partition function boundary values list. Partition boundary values at ordinal %d and %d are equal.
770910Warning: Range value list for partition function ‘%.*ls’ is not sorted by value. Mapping of partitions to filegroups during CREATE PARTITION SCHEME will use the sorted boundary values if the function ‘%.*ls’ is referenced in CREATE PARTITION SCHEME.
771010Warning: The partition scheme ‘%.*ls’ does not have any next used filegroup. Partition scheme has not been changed.
771116The %ls option was specified more than once for the table, or for at least one of its partitions if the table is partitioned.
771210Partition scheme ‘%.*ls’ has been created successfully. ‘%.*ls’ is marked as the next used filegroup in partition scheme ‘%.*ls’.
771310%d filegroups specified after the next used filegroup are ignored.
771416Partition range value is missing.
771516The specified partition range value could not be found.
771616Can not create or alter a partition function to have zero partitions.
771716The partition scheme “%.*ls” is currently being used to partition one or more tables.
771816Partition range value cannot be specified for hash partitioning.
771916CREATE/ALTER partition function failed as only a maximum of %d partitions can be created.
772016Data truncated when converting range values to the partition function parameter type. The range value at ordinal %d requires data truncation.
772116Duplicate range boundary values are not allowed in partition function boundary values list. The boundary value being added is already present at ordinal %d of the boundary value list.
772216Invalid partition number %I64d specified for %S_MSG ‘%.*ls’, partition number can range from 1 to %d.
772316Only a single filegroup can be specified while creating partition scheme using option ALL to specify all the filegroups.
772416Computed column cannot be used as a partition key if it is not persisted. Partition key column ‘%.*ls’ in table ‘%.*ls’ is not persisted.
772516Alter partition function statement failed. Cannot repartition table ‘%.*ls’ by altering partition function ‘%.*ls’ because its clustered index ‘%.*ls’ is disabled.
772616Partition column ‘%.*ls’ has data type %s which is different from the partition function ‘%.*ls’ parameter data type %s.
772716Collation of partition column ‘%.*ls’ does not match collation of corresponding parameter in partition function ‘%.*ls’.
772816Invalid partition range: %d TO %d. Lower bound must not be greater than upper bound.
772916Cannot specify partition number in the %S_MSG %S_MSG statement as the %S_MSG ‘%.*ls’ is not partitioned.
773016Alter %S_MSG statement failed because partition number %d does not exist in %S_MSG ‘%.*ls’.
773116Cannot specify partition number in Alter %S_MSG statement to rebuild or reorganize a partition of %S_MSG ‘%.*ls’.
773216Cannot specify partition number in Alter index statement along with keyword ALL to rebuild partitions of table ‘%.*ls’ when the table does not have any regular indexes.
773316‘%ls’ statement failed. The %S_MSG ‘%.*ls’ is partitioned while %S_MSG ‘%.*ls’ is not partitioned.
773410The %S_MSG ‘%.*ls’ specified for the clustered index ‘%.*ls’ was used for table ‘%.*ls’ even though %S_MSG ‘%.*ls’ is specified for it.
773516Cannot specify partition number in alter %S_MSG statement to rebuild or reorganize a partition of %S_MSG ‘%.*ls’ as %S_MSG is not partitioned.
773616Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.
773716Filegroup %.*ls is of a different filegroup type than the first filegroup in partition scheme %.*ls
773816Cannot enable compression for object ‘%.*ls’. Only SQL Server Enterprise Edition supports compression.
773916The partition scheme of table ‘%.*ls’ cannot be changed because there exists one or more incremental statistics on the table.
774016A partition ID for at least one row has been modified.
780115The required parameter %.*ls was not specified.
780216Functions that have a return type of “%.*ls” are unsupported through SOAP invocation.
780315The clause %.*ls can not be used in the %.*ls statement.
780415%.*ls and %.*ls can not share the same value.
780516The parameter SITE can not be prefixed by a scheme such as ‘http://’.  Valid values for SITE include {‘*’ | ‘+’ | ‘site_name’}.
780616The URL specified by endpoint ‘%.*ls’ is already registered to receive requests or is reserved for use by another service.
780716An error (‘0x%x’) occurred while attempting to register the endpoint ‘%.*ls’.
780810The endpoint ‘%.*ls’ could not be unregistered.
780910Cannot find the object ‘%.*ls’, because it does not exist or you do not have permission.
781015The value ‘%d’ is not within range for the ‘%.*ls’ parameter.
781116COMPUTE BY queries are not supported over SOAP.
781210The endpoint ‘%.*ls’ has been established in metadata, but HTTP listening has not been enabled because HTTP support did not start successfully. Verify that the operating system and the edition of SQL Server supports native HTTP access. Check the SQL Server error log for any errors that might have occurred while starting HTTP support.
781316The parameter PATH must be supplied in its canonical form.  An acceptable PATH is ‘%.*ls’.
781410The specified value ‘%.*ls’ already exists.
781510The specified value ‘%.*ls’ does not exist.
781615A duplicate parameter was specified, ‘%.*ls’.
781716The Base64 encoded input data was malformed for the parameter “%.*ls”.
781816The request exceeds an internal limit. Simplify or reduce the size of the request.
781915The SOAP method object ‘%.*ls’ must be specified using a fully qualified three-part name.
782016SOAP namespaces beginning with ‘%.*ls’ are disallowed because they are reserved for system use.
782110Cannot find the database ‘%.*ls’, because it does not exist or you do not have permission.
782216An unexpected XML node “%.*ls” (in the namespace “%.*ls”) was found in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
782316The “%.*ls” XML element (in the “%.*ls” namespace) was expected in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
782416The “%.*ls” XML element (in the “%.*ls” namespace) was expected as the topmost node of the SOAP request.
782516A SOAP method element was expected in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
782616Unexpected character data was found in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
782714The user does not have permission to reserve and unreserve HTTP namespaces.
782811The statement is not supported on this version of the operating system. Could not find Httpapi.dll in the path.
782911The statement is not supported on this version of the operating system. Could not find function entry point  ‘%.*ls’ in Httpapi.dll.
783016Unable to complete the operation because of an unexpected error.
783116A reservation for this HTTP namespace (%.*ls) already exists.
783216A reservation for this HTTP namespace (%.*ls) does not exist.
783316The HTTP namespace (%.*ls) is in an invalid format. Specify the namespace in its canonical form.
783410The reservation for the HTTP namespace (%.*ls) has been deleted. If there are any endpoints associated with this namespace, they will continue to receive and process requests until the server is restarted.
783516Endpoint ‘%.*ls’ has been disabled because it is insecurely configured. For a more information, attempt to start the endpoint using the ALTER ENDPOINT statement.
783620A fatal error occurred while reading the input stream from the network. The maximum number of network packets in one request was exceeded. Try using bulk insert, increasing network packet size, or reducing the size of the request. The session will be terminated.
784716XML data was found in the parameter ‘%.*ls’ which is not an XML parameter.  Please entitize any invalid XML character data in this parameter, or pass the parameter in typed as XSD:anyType or sqltypes:xml.
784815An invalid or unsupported localeId was specified for parameter “%.*ls”.
784915Invalid sqlCompareOptions were specified for parameter “%.*ls”.
785016The SQL Server Service account does not have permission to register the supplied URL on the endpoint ‘%.*ls’.  Use sp_reserve_http_namespace to explicitly reserve the URL namespace before you try to register the URL again.
785115The %.*ls attribute must be specified on the %.*ls element of the parameter “%.*ls” because it is of type %.*ls.
785215Parameter “%.*ls”: If the %.*ls attribute appears on a parameter value node of type “%.*ls” (in the namespace “%.*ls”), it must refer to a CLR type.
785316The URL specified as the path (“%.*ls”) is not in an absolute format, and must begin with “%.*ls”.
785416The URL value specified for the “%.*ls” parameter is too long.
785515Reading from HTTP input stream failed.
785616XML parameters do not support non-unicode element or attribute values.
785716Parameter “%.*ls”: Function or procedure parameters with improperly formatted or deprecated names are not supported through Native SOAP access. Refer to documentation for rules concerning the proper naming of parameters.
785816The “%.*ls” XML element (in the “%.*ls” namespace) in the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request contained an invalid binary type.
785915Parameter “%.*ls”: Parameter collation cannot be specified on the “%.*ls” node (in the namespace “%.*ls”).
786015An endpoint’s transport or content cannot be changed through the ALTER ENDPOINT statement. Use DROP ENDPOINT and execute the CREATE ENDPOINT statement to make these changes.
786115%.*ls endpoints can only be of the “FOR %.*ls” type.
786216An endpoint of the requested type already exists.  Only one endpoint of this type is supported.  Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.
786316The endpoint was not changed. The ALTER ENDPOINT statement did not contain any values to modify or update.
786416CREATE/ALTER ENDPOINT cannot be used to update the endpoint with this information.  The Dedicated Administrator Connection endpoint is reserved and cannot be updated.
786516Web Services Description Language (WSDL) generation failed because the system was unable to query the metadata for the endpoint.
786616XML attribute and element values larger than 4000 characters are only allowed within the SOAP Body node.
786715An invalid sqlCollationVersion was specified for parameter “%.*ls”.
786815An invalid sqlSortId was specified for parameter “%.*ls”.
786916The endpoint name ‘%.*ls’ is reserved for used by SQL.  Endpoint names cannot begin with ‘%.*ls’.
787016The AFFINITY clause is not supported for endpoints of this type.
787116The clause “%.*ls” is not valid for this endpoint type.
787216%.*ls is not a parameter for procedure “%.*ls”, or it was supplied out of order.
787316The endpoint “%.*ls” is a built-in endpoint and cannot be dropped. Use the protocol configuration utilities to ADD or DROP Transact-SQL endpoints.
787416An endpoint already exists with the bindings specified.  Only one endpoint supported for a specific binding.  Use ALTER ENDPOINT or DROP the existing endpoint and execute the CREATE ENDPOINT statement.
787516An unexpected XML construct was found in the character data of the “%.*ls” element (in the “%.*ls” namespace) of the SOAP request.
787616The operation is not supported because current connection is made to contained availability group. Reconnect to SQL Instance and retry the operation.
787816This “%.*ls ENDPOINT” statement is not supported on this edition of SQL Server.
787910SQL Server is waiting for %d remaining sessions and connections to close. If these sessions are not closed within a reasonable amount of time, “polite” shutdown will be aborted. This message may appear several times before SQL Server is shutdown.
788010SQL Server has successfully finished closing sessions and connections.
788110SQL Server was unable to close sessions and connections in a reasonable amount of time and is aborting “polite” shutdown.
788216OUTPUT was requested for parameter ‘%.*ls’, which is not supported for a WEBMETHOD with FORMAT=NONE.
788316User-defined functions cannot be used for a WEBMETHOD with FORMAT=NONE.
788420Violation of tabular data stream (TDS) protocol. This is most often caused by a previous exception on this task. The last exception on the task was error %d, severity %d, address 0x%p. This connection will be terminated.
788520Network error 0x%lx occurred while sending data to the client on process ID %d batch ID %d. A common cause for this error is if the client disconnected without reading the entire response from the server. This connection will be terminated.
788620A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.
788720The IPv6 address specified is not supported.  Only addresses that are in their numeric, canonical form are supported for listening.
788820The IPv6 address specified is not supported.  The server may not be configured to allow for IPv6 connectivity, or the address may not be in a recognized IPv6 format.
788916The SOAP headers on the request have exceeded the size limits established for this endpoint.  The endpoint owner may increase these limits via ALTER ENDPOINT.
789016An error occurred while attempting to register the endpoint ‘%.*ls’.  One or more of the ports specified in the CREATE ENDPOINT statement may be bound to another process. Attempt the statement again with a different port or use netstat to find the application currently using the port and resolve the conflict.
789110Creation of a TSQL endpoint will result in the revocation of any ‘Public’ connect permissions on the ‘%.*ls’ endpoint.  If ‘Public’ access is desired on this endpoint, reapply this permission using ‘GRANT CONNECT ON ENDPOINT::[%.*ls] to [public]’.
789216Internal subset DTDs inside SOAP requests are not allowed.
789315Parameter ‘%.*ls’:  Incompatible XML attributes were present.  The ‘%.*ls’ attribute and the ‘%.*ls’ attribute may not both be present on a parameter value node of type ‘%.*ls’ (in the namespace ‘%.*ls’).
789416Listening has not been started on the endpoint ‘%.*ls’ found in metadata.  Endpoint operations are disabled on this edition of SQL Server.
789514Only a system administrator can specify a custom WSDL stored procedure on the endpoint.
789616The column or parameter ‘%.*ls’ uses a data type not supported by SOAP.  SOAP only supports data types supported in SQL Server 2005 or earlier.
789710Creating and altering SOAP endpoints will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
789810SQL Server native SOAP support is now deprecated and will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use it.
789916The return value uses a data type not supported by SOAP.  SOAP only supports data types supported in SQL Server 2005 or earlier.
790116The repair statement was not processed. This level of repair is not supported when the database is in emergency mode.
790216Columnstore index ‘%.*ls’ on table ‘%.*ls’ has metadata mismatch on column id %d and rowgroup id %d. If this is a nonclustered columnstore index, drop it and recreate it. Otherwise, contact CSS.
790316Table error: The orphaned file “%.*ls” was found in the FILESTREAM directory ID %.*ls container ID %d for object ID %d, index ID %d, partition ID %I64d, column ID %d.
790416Table error: Cannot find the FILESTREAM file “%.*ls” for column ID %d (column directory ID %.*ls container ID %d) in object ID %d, index ID %d, partition ID %I64d, page ID %S_PGID, slot ID %d.
790516Database error: The directory “%.*ls” is not a valid FILESTREAM directory in container ID %d.
790616Database error: The file “%.*ls” is not a valid FILESTREAM file in container ID %d.
790716Table error: The directory “%.*ls” under the rowset directory ID %.*ls is not a valid FILESTREAM directory in container ID %d.
790816Table error: The file “%.*ls” in the rowset directory ID %.*ls is not a valid FILESTREAM file in container ID %d.
790920The emergency-mode repair failed.You must restore from backup.
791010Repair: The page %S_PGID has been allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
791110Repair: The page %S_PGID has been deallocated from object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
791210Repair: The extent %S_PGID has been allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
791310Repair: The extent %S_PGID has been deallocated from object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
791410Repair: %ls page at %S_PGID has been rebuilt.
791510Repair: IAM chain for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), has been truncated before page %S_PGID and will be rebuilt.
791610Repair: Deleted record for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), on page %S_PGID,  slot %d. Indexes will be rebuilt.
791710Repair: Converted forwarded record for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), at page %S_PGID, slot %d to a data row.
791810Repair: Page %S_PGID next and %S_PGID previous pointers have been set to match each other in object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
791916Repair statement not processed. Database needs to be in single user mode.
792010Processed %ld entries in system catalog for database ID %d.
792116Repair statement not processed. Database cannot be a snapshot.
792216***************************************************************
792310Table %.*ls                Object ID %ld.
792410Index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). FirstIAM %S_PGID. Root %S_PGID. Dpages %I64d.
792510Index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). %I64d pages used in %I64d dedicated extents.
792616Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Microsoft Knowledge Base article 928518 for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
792710Total number of extents is %I64d.
792816The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
792916Check statement aborted.  Database contains deferred transactions.
793016Mirroring must be removed from the database for this DBCC command.
793116Database error: The FILESTREAM directory ID %.*ls for a partition was seen two times.
793216Table error: The FILESTREAM directory ID %.*ls for object ID %d, index ID %d, partition ID %I64d is in filegroup %d, but should be in filegroup %d.
793316Table error: A FILESTREAM directory ID %.*ls exists for a partition, but the corresponding partition does not exist in the database.
793416DBCC CHECK cannot proceed on database %.*ls because it is a Secondary Replica and either Snapshot creation failed or the WITH TABLOCK option was specified. Secondary Replica databases cannot be exclusively locked for DBCC CHECK. Reason may have been given in previous error.
793516Table error: A FILESTREAM directory ID %.*ls exists for a column of object ID %d, index ID %d, partition ID %I64d, but that column does not exist in the partition.
793616Table error: The FILESTREAM directory ID %.*ls exists for column ID %d of object ID %d, index ID %d, partition ID %I64d, but that column is not a FILESTREAM column.
793716Columnstore index has one or more missing column segments. Please run DBCC CHECKDB for more information.
793816Table error: object ID %d, index ID %d, partition ID %I64d processing encountered file name “%.*ls” twice in the column directory %d container ID %d (for column ID %d).
793916Cannot detach database ‘%.*ls’ because it does not exist.
794016System databases master, model, msdb, and tempdb cannot be detached.
794116Table error: object ID %d, index ID %d, partition ID %I64d processing encountered file name “%.*ls” twice in the column ID %d (for column directory %d container ID %d).
794210DBCC %ls scanning ‘%.*ls’ table…
794310Table: ‘%.*ls’ (%d); index ID: %d, database ID: %d
794410%ls level scan performed.
794510– Pages Scanned…………………………..: %I64d
794610– Extents Scanned…………………………: %I64d
794710– Extent Switches…………………………: %I64d
794810– Avg. Pages per Extent……………………: %3.1f
794910– Scan Density [Best Count:Actual Count]…….: %4.2f%ls [%I64d:%I64d]
795010– Logical Scan Fragmentation ………………: %4.2f%ls
795110Warning:  Could not complete filestream consistency checks due to an operating system error.  Any consistency errors found in the filestream subsystem will be silenced.  Please refer to other errors for more information.  This condition is likely transient; try rerunning the command.
795210– Extent Scan Fragmentation ……………….: %4.2f%ls
795310– Avg. Bytes Free per Page…………………: %3.1f
795410– Avg. Page Density (full)…………………: %4.2f%ls
795516Invalid SPID %d specified.
795616Table error: The FILESTREAM file “%.*ls” for column ID %d was found in column directory ID %.*ls of container ID %d but should be in container ID %d in object ID %d, index ID %d, partition ID %I64d, page ID %S_PGID, slot ID %d.
795710Cannot display the specified SPID’s buffer; in transition.
795816The specified SPID does not process input/output data streams.
795916Columnstore index has one or more missing dictionaries. Please run DBCC CHECKDB for more info.
796016An invalid server process identifier (SPID) %d or batch ID %d was specified.
796116Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) , page ID %S_PGID, row ID %d. Column ‘%.*ls’ is a var column with a NULL value and non-zero data length
796216Invalid BATCHID %d specified.
796316Database error: The file “%.*ls” is not a valid FILESTREAM LOG file in container ID %d.
796410Repair: Deleted FILESTREAM file “%.*ls” for column ID %d, for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) on page %S_PGID, slot %d.
796516Table error: Could not check object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) due to invalid allocation (IAM) page(s).
796610Warning: NO_INDEX option of %ls being used. Checks on non-system indexes will be skipped.
796716Clustered columnstore index ‘%.*ls’ on table ‘%.*ls’ has a missing column segment on column id %d and rowgroup id %d. Restore the data from a backup.
796810Transaction information for database ‘%.*ls’.
796916No active open transactions.
797010%hsOldest active transaction:
797110    SPID (server process ID): %d%s
797210    UID (user ID) : %d
797316Clustered column store index ‘%.*ls’ on table ‘%.*ls’ has erroneous content in its mapping index.
797410    Name          : %.*ls
797510    LSN           : (%d:%d:%d)
797616Nonclustered columnstore index ‘%.*ls’ on table ‘%.*ls’ has a missing column segment on column id %d and rowgroup id %d. Drop and recreate the nonclustered columnstore index.
797710    Start time    : %.*ls
797810    SID           : %.*ls
797910%hsReplicated Transaction Information:
798010        Oldest distributed LSN     : (%d:%d:%d)
798116Clustered columnstore index ‘%.*ls’ on table ‘%.*ls’, column ‘%.*ls’ has one or more values out of range for data type ‘%.*ls’. Restore the data from a backup.
798210        Oldest non-distributed LSN : (%d:%d:%d)
798314User ‘%.*ls’ does not have permission to run DBCC %ls for database ‘%.*ls’.
798416System table pre-checks: Object ID %d. Page %S_PGID has unexpected page type %d. Check statement terminated due to unrepairable error.
798516System table pre-checks: Object ID %d. Could not read and latch page %S_PGID with latch type %s. Check statement terminated due to unrepairable error.
798616System table pre-checks: Object ID %d has cross-object chain linkage. Page %S_PGID points to %S_PGID in alloc unit ID %I64d (should be %I64d). Check statement terminated due to unrepairable error.
798716System table pre-checks: Object ID %d has chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->prev = %S_PGID. Check statement terminated due to unrepairable error.
798816System table pre-checks: Object ID %d. Loop in data chain detected at %S_PGID. Check statement terminated due to unrepairable error.
798916Checking identity information: current identity value ‘%.*hs’.
799116Clustered columnstore index ‘%.*ls’ on table ‘%.*ls’ has a missing dictionary on column id %d and rowgroup id %d. Restore the data from a backup.
799216Cannot shrink ‘read only’ database ‘%.*ls’.
799310Cannot shrink file ‘%d’ in database ‘%.*ls’ to %u pages as it only contains %u pages.
799410DBCC CheckDatabase on resource database will be skipped because user ‘%.*ls’ does not have permission.
799516Database ‘%.*ls’: consistency errors in system catalogs prevent further DBCC %ls processing.
799616Extended stored procedures can only be created in the master database.
799716‘%.*ls’ does not contain an identity column.
799816Checking identity information: current identity value ‘%.*hs’, current column value ‘%.*hs’.
799916Could not find any index named ‘%.*ls’ for table ‘%.*ls’.