Web.QHMIT.com

SQL Server System Errors: 7000 - 7999

List of error messages between 7000 and 7999 in SQL Server 2017.

These error messages are all available by querying the sys.messages catalog view on the master database.

message_id severity is_event_logged text
7000160OPENXML document handle parameter must be of data type int.
7001160OPENXML flags parameter must be of data type int.
7002160OPENXML XPath must be of a string data type, such as nvarchar.
7003160Only one OPENXML column can be of type %ls.
7004160OPENXML does not support retrieving schema from remote tables, as in '%.*ls'.
7005160OPENXML requires a metaproperty namespace to be declared if 'mp' is used for another namespace in sp_xml_preparedocument.
7006160OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement.
7007160OPENXML encountered unknown metaproperty '%.*ls'.
7008160The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.
7009160OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument.
7101160You need an active user transaction in order to use text pointers for a table with the option "text in row" set to ON.
7102201Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.
7104160Offset or size of data type is not valid. Data type must be of type int or smallint.
7105221The 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.
7106161Internal error: An attempt was made to update a LOB data type using a read-only text pointer.
7107160You can have only 1,024 in-row text pointers in one transaction
7108221Database ID %d, page %S_PGID, slot %d, link number %d is invalid. Run DBCC CHECKTABLE.
7116160Offset %d is not in the range of available LOB data.
7117160Error reading large object (LOB) data from the tabular data stream (TDS).
7118160Only complete replacement is supported when assigning a large object (LOB) to itself.
7119160Attempting to grow LOB beyond maximum allowed size of %I64d bytes.
7122160Invalid text, ntext, or image pointer type. Must be binary(16).
7123160Invalid text, ntext, or image pointer value %hs.
7124160The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
7125160The text, ntext, or image pointer value conflicts with the column name specified.
7133160NULL textptr (text, ntext, or image pointer) passed to %ls function.
7134160LOB Locator is not supported as text pointer when using UPDATETEXT/WRITETEXT to update/write a text column.
7135160Deletion length %ld is not in the range of available text, ntext, or image data.
7137160%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.
7138160The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS) or tracked by Change Data Capture.
7139160Length 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.
7140160Cannot 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.
7141160Must create orphaned text inside a user transaction.
7143160Invalid locator de-referenced.
7144160A text/ntext/image column referenced by a persisted or indexed computed column cannot be updated
7151160Insufficient buffer space to perform write operation.
7152160READEXT, WRITETEXT, and UPDATETEXT statements cannot be used on tables that are referenced by an enabled security policy.
7201170Could 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.
7202110Could 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.
7212160Could not execute procedure '%.*ls' on remote server '%.*ls'.
7213201The 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.
7214161Remote procedure time out of %d seconds exceeded. Remote procedure '%.*ls' is canceled.
7215160Could not execute statement on remote server '%.*ls'.
7221160Could not relay results of procedure '%.*ls' from remote server '%.*ls'.
7301160Cannot obtain the required interface ("%ls") from OLE DB provider "%ls" for linked server "%ls".
7302160Cannot create an instance of OLE DB provider "%ls" for linked server "%ls".
7303160Cannot initialize the data source object of OLE DB provider "%ls" for linked server "%ls".
7304160Cannot connect using OLE DB provider "%ls" to linked server "%ls". Verify the connection parameters or login credentials associated with this linked server.
7305160Cannot create a statement object using OLE DB provider "%ls" for linked server "%ls".
7306160Cannot open the table "%ls" from OLE DB provider "%ls" for linked server "%ls". %ls
7307160Cannot obtain the data source of a session from OLE DB provider "%ls" for linked server "%ls". This action must be supported by the provider.
7308160OLE DB provider '%ls' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
7310160Cannot 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.
7311160Cannot 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.
7312160Invalid 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.
7313160An invalid schema or catalog was specified for the provider "%ls" for linked server "%ls".
7314160The 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.
7315160The OLE DB provider "%ls" for linked server "%ls" contains multiple tables that match the name "%ls".
7316160Cannot use qualified table names (schema or catalog) with the OLE DB provider "%ls" for linked server "%ls" because it does not implement required functionality.
7317160The OLE DB provider "%ls" for linked server "%ls" returned an invalid schema definition.
7318160The OLE DB provider "%ls" for linked server "%ls" returned an invalid column definition for table "%ls".
7319160The OLE DB provider "%ls" for linked server "%ls" returned a "%ls" index "%ls" with the incorrect bookmark ordinal %d.
7320160Cannot execute the query "%ls" against OLE DB provider "%ls" for linked server "%ls". %ls
7321160An error occurred while preparing the query "%ls" for execution against OLE DB provider "%ls" for linked server "%ls". %ls
7322160A failure occurred while giving parameter information to OLE DB provider "%ls" for linked server "%ls".
7323160An error occurred while submitting the query text to OLE DB provider "%ls" for linked server "%ls".
7324160A failure occurred while setting parameter properties with OLE DB provider "%ls" for linked server "%ls".
7325160Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object '%ls'.
7326160An error occurred while retrieving the query text from OLE DB provider "%ls" for linked server "%ls".
7327160A failure occurred while retrieving parameter information to OLE DB provider "%ls" for linked server "%ls".
7330160Cannot fetch a row from OLE DB provider "%ls" for linked server "%ls".
7331160Rows from OLE DB provider "%ls" for linked server "%ls" cannot be released.
7332160Cannot rescan the result set from OLE DB provider "%ls" for linked server "%ls". %ls
7333160Cannot fetch a row using a bookmark from OLE DB provider "%ls" for linked server "%ls".
7339160OLE DB provider '%ls' for linked server '%ls' returned invalid data for column '%ls.%ls'.
7340160Cannot create a column accessor for OLE DB provider "%ls" for linked server "%ls".
7341160Cannot get the current row value of column "%ls.%ls" from OLE DB provider "%ls" for linked server "%ls". %ls
7342160An unexpected NULL value was returned for column "%ls.%ls" from OLE DB provider "%ls" for linked server "%ls". This column cannot be NULL.
7343160The OLE DB provider "%ls" for linked server "%ls" could not %ls table "%ls". %ls
7344160The OLE DB provider "%ls" for linked server "%ls" could not %ls table "%ls" because of column "%ls". %ls
7345160The OLE DB provider "%ls" for linked server "%ls" could not delete from table "%ls". %ls
7346160Cannot get the data of the row from the OLE DB provider "%ls" for linked server "%ls". %ls
7347160OLE 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.
7348160The 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.
7349160The OLE DB provider "%ls" for linked server "%ls" could not set the range for table "%ls" because of column "%ls". %ls
7350160Cannot get the column information from OLE DB provider "%ls" for linked server "%ls".
7351160The OLE DB provider "%ls" for linked server "%ls" could not map ordinals for one or more columns of object "%ls".
7352160The OLE DB provider "%ls" for linked server "%ls" supplied inconsistent metadata. The object "%ls" was missing the expected column "%ls".
7353160The 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.
7354160The OLE DB provider "%ls" for linked server "%ls" supplied invalid metadata for column "%ls". %ls
7355160The OLE DB provider "%ls" for linked server "%ls" supplied inconsistent metadata for a column. The name was changed at execution time.
7356160The 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.
7357160Cannot 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.
7358160Cannot 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".
7359160The 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".
7360160Cannot get the length of a storage object from OLE DB provider "%ls" for linked server "%ls" for table "%ls", column "%ls".
7361160Cannot read a storage object from OLE DB provider "%ls" for linked server "%ls", for table "%ls", column "%ls".
7362160The OLE DB provider "%ls" for linked server "%ls" reported different metadata at run time for table "%ls", column "%ls".
7365160Cannot obtain optional metadata columns of columns rowset from OLE DB provider "%ls" for linked server "%ls".
7366160Cannot obtain columns rowset from OLE DB provider "%ls" for linked server "%ls".
7367160The OLE DB provider "%ls" for linked server "%ls" supports column level collation, but failed to provide the metadata column "%ls" at run time.
7368160The OLE DB provider "%ls" for linked server "%ls" supports column level collation, but failed to provide collation data for column "%ls".
7369160The OLE DB provider '%ls' for linked server '%ls' provided invalid collation. LCID = %08x, Compflags = %08x, SortOrder = '%.*ls'.
7370160One or more properties could not be set on the query for OLE DB provider "%ls" for linked server "%ls". %ls
7371160The server option 'collation name' in linked server '%ls' for OLE DB provider '%ls' has collation id %08x which is not supported by SQL Server.
7372160Cannot get properties from OLE DB provider "%ls" for linked server "%ls".
7373160Cannot set the initialization properties for OLE DB provider "%ls" for linked server "%ls".
7374160Cannot set the session properties for OLE DB provider "%ls" for linked server "%ls".
7375160Cannot open index "%ls" on table "%ls" from OLE DB provider "%ls" for linked server "%ls". %ls
7376160Could not enforce the remote join hint for this query.
7377160Cannot specify an index hint for a remote data source.
7380160Table-valued parameters are not allowed in remote calls between servers.
7390160The requested operation could not be performed because OLE DB provider "%ls" for linked server "%ls" does not support the required transaction interface.
7391160The operation could not be performed because OLE DB provider "%ls" for linked server "%ls" was unable to begin a distributed transaction.
7392160Cannot start a transaction for OLE DB provider "%ls" for linked server "%ls".
7393160The OLE DB provider "%ls" for linked server "%ls" reported an error 0x%08X aborting the current transaction.
7394160The OLE DB provider "%ls" for linked server "%ls" reported an error committing the current transaction.
7395160Unable 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.
7396160Varchar(max), nvarchar(max), varbinary(max) and large CLR type data types are not supported as return value or output parameter to remote queries.
7397160Remote function returned varchar(max), nvarchar(max), varbinary(max) or large CLR type value which is not supported.
7398160The OLE DB provider '%ls' for linked server '%ls' reported an error committing the current inserts.
7399160The OLE DB provider "%ls" for linked server "%ls" reported an error. %ls
7401160The OLE DB provider "%ls" returned invalid literal prefix/suffix string.
7403160The OLE DB provider "%ls" has not been registered.
7404160The server could not load DCOM.
7405160Heterogeneous 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.
7409160Could 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.
7410160Remote access is not allowed for impersonated security context.
7411160Server '%.*ls' is not configured for %ls.
7412160OLE DB provider "%ls" for linked server "%ls" returned message "%ls".
7413160Could not connect to linked server '%ls' (OLE DB Provider '%ls'). Enable delegation or use a remote SQL Server login for the current user.
7414160Invalid number of parameters. Rowset '%ls' expects %d parameter(s).
7415160Ad hoc access to OLE DB provider '%ls' has been denied. You must access this provider through a linked server.
7416160Access to the remote server is denied because no login-mapping exists.
7417160GROUP BY ALL is not supported in queries that access remote tables if there is also a WHERE clause in the query.
7418160Text, image, or ntext column was too large to send to the remote data source due to the storage interface used by the provider.
7419160Lazy schema validation error. Linked server schema version has changed. Re-run the query.
7420160Remote access is not supported for transaction isolation level "%ls".
7421100Cannot fetch the rowset from OLE DB provider "%ls" for linked server "%ls". %ls.
7422160OLE DB provider "%ls" for linked server "%ls" returned an invalid index definition for table "%ls".
7423160The '%ls' OLE DB provider for the '%ls' linked server returned an invalid CLR type definition for the '%ls' table.
7424100OLE DB provider "%ls" for linked server "%ls" returned "%ls" with data type "%ls", which should be type "%ls".
7425100OLE DB provider "%ls" for linked server "%ls" returned an incorrect value for "%ls", which should be "%ls".
7426100OLE DB provider "%ls" for linked server "%ls" returned "%ls" without "%ls" being supported.
7427100OLE DB provider "%ls" for linked server "%ls" returned "%ls" for "%ls" during statistics gathering.
7428100OLE DB provider "%ls" for linked server "%ls" supported the schema lock interface, but returned "%ls" for "%ls".
7429100%hs SQL Server Remote Metadata Gather Time for Table %s.%s:%hs, CPU time = %lu ms, elapsed time = %lu ms.
7430160Out-of-process use of OLE DB provider "%ls" with SQL Server is not supported.
7431160Unable to delete OLE DB parameter properties.
7432160Heterogeneous queries and use of OLEDB providers are not supported in fiber mode.
7433100OLE 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.
7435160The OLE DB provider "%ls" for linked server "%ls" returned unexpected NULL pointer for string column "%ls.%ls".
7436160The 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.
7437160Linked servers cannot be used under impersonation without a mapping for the impersonated login.
7438160The 32-bit OLE DB provider "%ls" cannot be loaded in-process on a 64-bit SQL Server.
7601160Cannot use a CONTAINS or FREETEXT predicate on %S_MSG '%.*ls' because it is not full-text indexed.
7604170Full-text operation failed due to a time out.
7606170Could not find full-text index for database ID %d, table or indexed view ID %d.
7607170Search 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).
7608160An unknown full-text failure (0x%x) occurred during "%hs".
7609170Full-Text Search is not installed, or a full-text component cannot be loaded.
7610160Access is denied to "%.*ls", or the path is invalid.
7613160Cannot drop index '%.*ls' because it enforces the full-text key for table or indexed view '%.*ls'.
7614160Cannot alter or drop column '%.*ls' because it is enabled for Full-Text Search.
7615160A CONTAINS or FREETEXT predicate can only operate on one table or indexed view. Qualify the use of * with a table or indexed view name.
7616160Full-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.
7617160Query does not reference the full-text indexed table or indexed view, or user does not have permission to perform this action.
7619160The execution of a full-text query failed. "%ls"
7620160The conversion to data type %ls failed for the full-text search key.
7621160Invalid use of full-text predicate in the HAVING clause.
7622170There is not sufficient disk space to complete this operation for the full-text catalog "%ls".
7624160Full-text catalog '%ls' is in an unusable state. Drop and re-create this full-text catalog.
7625160Full-text table or indexed view has more than one LCID among its full-text indexed columns.
7626150The top_n_by_rank argument ('%d') must be greater than or equal to zero.
7627160Cannot 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.
7629170Cannot open or query the full-text default path registry key. The full-text default catalog path is invalid.
7630150Syntax error near '%.*ls' in the full-text search condition '%.*ls'.
7632150The value of the Weight argument must be between 0.0 and 1.0.
7636100Warning: 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.
7638100Warning: Request to stop change tracking has deleted all changes tracked on table or indexed view '%ls'.
7640100Warning: Request to stop tracking changes on table or indexed view '%.*ls' will not stop population currently in progress on the table or indexed view.
7641160Full-Text catalog '%ls' does not exist in database '%.*ls' or user does not have permission to perform this action.
7642160A full-text catalog named '%ls' already exists in this database. Use a different name.
7644160Full-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.
7645160Null or empty full-text predicate.
7646160Fulltext predicate references columns from two different tables or indexed views '%.*ls' and '%.*ls' which is not allowed.
7647100Warning: Configuration of full-text catalog at '%ls' could not be saved during detach database.
7648100Warning: Failed to attach full-text catalog '%ls'.
7649100Warning: Failed to dismount full-text catalog at '%ls'.
7650100Warning: Failed to drop full-text catalog at '%ls'.
7651100Warning: 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.
7652160A full-text index for table or indexed view '%.*ls' has already been created.
7653160'%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.
7654160Unable to obtain the population status of the table or indexed view '%.*ls'.
7655160TYPE COLUMN option must be specified with column of image or varbinary(max) type.
7656160Full-text index for table or indexed view '%.*ls' cannot be populated because the database is in single-user access mode.
7657100Warning: 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.
7658160Table or indexed view '%.*ls' does not have a full-text index or user does not have permission to perform this action.
7659160Cannot activate full-text search for table or indexed view '%.*ls' because no columns have been enabled for full-text search.
7660160Full-text search must be activated on table or indexed view '%.*ls' before this operation can be performed.
7661100Warning: Full-text change tracking is currently enabled for table or indexed view '%.*ls'.
7662100Warning: Full-text auto propagation is currently enabled for table or indexed view '%.*ls'.
7663160Option 'WITH NO POPULATION' should not be used when change tracking is enabled.
7664160Full-text change tracking must be started on table or indexed view '%.*ls' before the changes can be flushed.
7665160Full 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.
7666160User does not have permission to perform this action.
7668160Cannot drop full-text catalog '%ls' because it contains a full-text index.
7669100Warning: 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.
7670160Column '%.*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.
7671160Column '%.*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.
7672160A full-text index cannot be created on the table or indexed view because duplicate column '%.*ls' is specified.
7673100Warning: Full-text change tracking is currently disabled for table or indexed view '%.*ls'.
7674100Warning: The fulltext catalog '%.*ls' is being dropped and is currently set as default.
7676100Warning: Full-text auto propagation is on. Stop crawl request is ignored.
7677160Column "%.*ls" is not full-text indexed.
7678160The following string is not defined as a language alias in syslanguages: %.*ls.
7679160Full-text index language of column "%.*ls" is not a language supported by full-text search.
7680160Default full-text index language is not a language supported by full-text search.
7681100Warning: 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.
7682100The component '%ls' reported error while indexing. Component path '%ls'.
7683160Errors 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.
7684100Error '%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.
7685100Error '%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.
7686100Cannot 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.
7689160Execution of a full-text operation failed. '%ls'
7690160Full-text operation failed because database is read only.
7691160Access is denied to full-text log path. Full-text logging is disabled for database '%ls', catalog '%ls' (database ID '%d', catalog ID '%d').
7692160Full-text catalog path '%.*ls' exceeded %d character limit.
7693160Full-text initialization failed to create a memory clerk.
7694160Failed to pause catalog for backup. Backup was aborted.
7696160Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed.
7697100Warning: 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.
7698160GROUP BY ALL cannot be used in full text search queries.
7699160TYPE COLUMN option is not allowed for column types other than image or varbinary(max).
7702160Empty Partition function type-parameter-list is not allowed when defining a partition function.
7703160Can not create RANGE partition function with multiple parameter types.
7704160The type '%.*ls' is not valid for this operation.
7705160Could not implicitly convert range values type specified at ordinal %d to partition function parameter type.
7706160Partition function '%ls' is being used by one or more partition schemes.
7707160The associated partition function '%ls' generates more partitions than there are file groups mentioned in the scheme '%ls'.
7708160Duplicate range boundary values are not allowed in partition function boundary values list. Partition boundary values at ordinal %d and %d are equal.
7709100Warning: 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.
7710100Warning: The partition scheme '%.*ls' does not have any next used filegroup. Partition scheme has not been changed.
7711160The %ls option was specified more than once for the table, or for at least one of its partitions if the table is partitioned.
7712100Partition scheme '%.*ls' has been created successfully. '%.*ls' is marked as the next used filegroup in partition scheme '%.*ls'.
7713100%d filegroups specified after the next used filegroup are ignored.
7714160Partition range value is missing.
7715160The specified partition range value could not be found.
7716160Can not create or alter a partition function to have zero partitions.
7717160The partition scheme "%.*ls" is currently being used to partition one or more tables.
7718160Partition range value cannot be specified for hash partitioning.
7719160CREATE/ALTER partition function failed as only a maximum of %d partitions can be created.
7720160Data truncated when converting range values to the partition function parameter type. The range value at ordinal %d requires data truncation.
7721160Duplicate 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.
7722160Invalid partition number %I64d specified for %S_MSG '%.*ls', partition number can range from 1 to %d.
7723160Only a single filegroup can be specified while creating partition scheme using option ALL to specify all the filegroups.
7724160Computed column cannot be used as a partition key if it is not persisted. Partition key column '%.*ls' in table '%.*ls' is not persisted.
7725160Alter partition function statement failed. Cannot repartition table '%.*ls' by altering partition function '%.*ls' because its clustered index '%.*ls' is disabled.
7726160Partition column '%.*ls' has data type %s which is different from the partition function '%.*ls' parameter data type %s.
7727160Collation of partition column '%.*ls' does not match collation of corresponding parameter in partition function '%.*ls'.
7728160Invalid partition range: %d TO %d. Lower bound must not be greater than upper bound.
7729160Cannot specify partition number in the %S_MSG %S_MSG statement as the %S_MSG '%.*ls' is not partitioned.
7730160Alter %S_MSG statement failed because partition number %d does not exist in %S_MSG '%.*ls'.
7731160Cannot specify partition number in Alter %S_MSG statement to rebuild or reorganize a partition of %S_MSG '%.*ls'.
7732160Cannot 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.
7733160'%ls' statement failed. The %S_MSG '%.*ls' is partitioned while %S_MSG '%.*ls' is not partitioned.
7734100The %S_MSG '%.*ls' specified for the clustered index '%.*ls' was used for table '%.*ls' even though %S_MSG '%.*ls' is specified for it.
7735160Cannot specify partition number in alter %S_MSG statement to rebuild or reorganize a partition of %S_MSG '%.*ls' as %S_MSG is not partitioned.
7736160Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of SQL Server supports partitioning.
7737160Filegroup %.*ls is of a different filegroup type than the first filegroup in partition scheme %.*ls
7738160Cannot enable compression for object '%.*ls'. Only SQL Server Enterprise Edition supports compression.
7739160The partition scheme of table '%.*ls' cannot be changed because there exists one or more incremental statistics on the table.
7740160A partition ID for at least one row has been modified.
7801150The required parameter %.*ls was not specified.
7802160Functions that have a return type of "%.*ls" are unsupported through SOAP invocation.
7803150The clause %.*ls can not be used in the %.*ls statement.
7804150%.*ls and %.*ls can not share the same value.
7805160The parameter SITE can not be prefixed by a scheme such as 'http://'. Valid values for SITE include {'*' | '+' | 'site_name'}.
7806160The URL specified by endpoint '%.*ls' is already registered to receive requests or is reserved for use by another service.
7807160An error ('0x%x') occurred while attempting to register the endpoint '%.*ls'.
7808100The endpoint '%.*ls' could not be unregistered.
7809100Cannot find the object '%.*ls', because it does not exist or you do not have permission.
7810150The value '%d' is not within range for the '%.*ls' parameter.
7811160COMPUTE BY queries are not supported over SOAP.
7812101The 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.
7813160The parameter PATH must be supplied in its canonical form. An acceptable PATH is '%.*ls'.
7814100The specified value '%.*ls' already exists.
7815100The specified value '%.*ls' does not exist.
7816150A duplicate parameter was specified, '%.*ls'.
7817160The Base64 encoded input data was malformed for the parameter "%.*ls".
7818160The request exceeds an internal limit. Simplify or reduce the size of the request.
7819150The SOAP method object '%.*ls' must be specified using a fully qualified three-part name.
7820160SOAP namespaces beginning with '%.*ls' are disallowed because they are reserved for system use.
7821100Cannot find the database '%.*ls', because it does not exist or you do not have permission.
7822160An unexpected XML node "%.*ls" (in the namespace "%.*ls") was found in the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request.
7823160The "%.*ls" XML element (in the "%.*ls" namespace) was expected in the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request.
7824160The "%.*ls" XML element (in the "%.*ls" namespace) was expected as the topmost node of the SOAP request.
7825160A SOAP method element was expected in the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request.
7826160Unexpected character data was found in the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request.
7827140The user does not have permission to reserve and unreserve HTTP namespaces.
7828110The statement is not supported on this version of the operating system. Could not find Httpapi.dll in the path.
7829110The statement is not supported on this version of the operating system. Could not find function entry point '%.*ls' in Httpapi.dll.
7830160Unable to complete the operation because of an unexpected error.
7831160A reservation for this HTTP namespace (%.*ls) already exists.
7832160A reservation for this HTTP namespace (%.*ls) does not exist.
7833160The HTTP namespace (%.*ls) is in an invalid format. Specify the namespace in its canonical form.
7834100The 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.
7835161Endpoint '%.*ls' has been disabled because it is insecurely configured. For a more information, attempt to start the endpoint using the ALTER ENDPOINT statement.
7836200A 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.
7847160XML 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.
7848150An invalid or unsupported localeId was specified for parameter "%.*ls".
7849150Invalid sqlCompareOptions were specified for parameter "%.*ls".
7850160The 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.
7851150The %.*ls attribute must be specified on the %.*ls element of the parameter "%.*ls" because it is of type %.*ls.
7852150Parameter "%.*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.
7853160The URL specified as the path ("%.*ls") is not in an absolute format, and must begin with "%.*ls".
7854160The URL value specified for the "%.*ls" parameter is too long.
7855150Reading from HTTP input stream failed.
7856160XML parameters do not support non-unicode element or attribute values.
7857160Parameter "%.*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.
7858160The "%.*ls" XML element (in the "%.*ls" namespace) in the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request contained an invalid binary type.
7859150Parameter "%.*ls": Parameter collation cannot be specified on the "%.*ls" node (in the namespace "%.*ls").
7860150An 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.
7861150"%.*ls" endpoints can only be of the "FOR %.*ls" type.
7862160An 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.
7863160The endpoint was not changed. The ALTER ENDPOINT statement did not contain any values to modify or update.
7864160CREATE/ALTER ENDPOINT cannot be used to update the endpoint with this information. The Dedicated Administrator Connection endpoint is reserved and cannot be updated.
7865160Web Services Description Language (WSDL) generation failed because the system was unable to query the metadata for the endpoint.
7866160XML attribute and element values larger than 4000 characters are only allowed within the SOAP Body node.
7867150An invalid sqlCollationVersion was specified for parameter "%.*ls".
7868150An invalid sqlSortId was specified for parameter "%.*ls".
7869160The endpoint name '%.*ls' is reserved for used by SQL. Endpoint names cannot begin with '%.*ls'.
7870160The AFFINITY clause is not supported for endpoints of this type.
7871160The clause "%.*ls" is not valid for this endpoint type.
7872160"%.*ls" is not a parameter for procedure "%.*ls", or it was supplied out of order.
7873160The endpoint "%.*ls" is a built-in endpoint and cannot be dropped. Use the protocol configuration utilities to ADD or DROP Transact-SQL endpoints.
7874160An 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.
7875160An unexpected XML construct was found in the character data of the "%.*ls" element (in the "%.*ls" namespace) of the SOAP request.
7878160This "%.*ls ENDPOINT" statement is not supported on this edition of SQL Server.
7879100SQL 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.
7880100SQL Server has successfully finished closing sessions and connections.
7881100SQL Server was unable to close sessions and connections in a reasonable amount of time and is aborting "polite" shutdown.
7882160OUTPUT was requested for parameter '%.*ls', which is not supported for a WEBMETHOD with FORMAT=NONE.
7883160User-defined functions cannot be used for a WEBMETHOD with FORMAT=NONE.
7884201Violation 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.
7885201Network 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.
7886201A 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.
7887201The IPv6 address specified is not supported. Only addresses that are in their numeric, canonical form are supported for listening.
7888201The 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.
7889160The SOAP headers on the request have exceeded the size limits established for this endpoint. The endpoint owner may increase these limits via ALTER ENDPOINT.
7890160An 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.
7891100Creation 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]'.
7892160Internal subset DTDs inside SOAP requests are not allowed.
7893150Parameter '%.*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').
7894161Listening has not been started on the endpoint '%.*ls' found in metadata. Endpoint operations are disabled on this edition of SQL Server.
7895140Only a system administrator can specify a custom WSDL stored procedure on the endpoint.
7896160The column or parameter '%.*ls' uses a data type not supported by SOAP. SOAP only supports data types supported in SQL Server 2005 or earlier.
7897100Creating 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.
7898101SQL 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.
7899160The return value uses a data type not supported by SOAP. SOAP only supports data types supported in SQL Server 2005 or earlier.
7901160The repair statement was not processed. This level of repair is not supported when the database is in emergency mode.
7902160Columnstore 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.
7903160Table 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.
7904160Table 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.
7905160Database error: The directory "%.*ls" is not a valid FILESTREAM directory in container ID %d.
7906160Database error: The file "%.*ls" is not a valid FILESTREAM file in container ID %d.
7907160Table error: The directory "%.*ls" under the rowset directory ID %.*ls is not a valid FILESTREAM directory in container ID %d.
7908160Table error: The file "%.*ls" in the rowset directory ID %.*ls is not a valid FILESTREAM file in container ID %d.
7909200The emergency-mode repair failed.You must restore from backup.
7910100Repair: The page %S_PGID has been allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
7911100Repair: The page %S_PGID has been deallocated from object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
7912100Repair: The extent %S_PGID has been allocated to object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
7913100Repair: The extent %S_PGID has been deallocated from object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls).
7914100Repair: %ls page at %S_PGID has been rebuilt.
7915100Repair: 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.
7916100Repair: 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.
7917100Repair: 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.
7918100Repair: 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).
7919160Repair statement not processed. Database needs to be in single user mode.
7920100Processed %ld entries in system catalog for database ID %d.
7921160Repair statement not processed. Database cannot be a snapshot.
7922160***************************************************************
7923100Table %.*ls Object ID %ld.
7924100Index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). FirstIAM %S_PGID. Root %S_PGID. Dpages %I64d.
7925100Index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls). %I64d pages used in %I64d dedicated extents.
7926160Check 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 Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
7927100Total number of extents is %I64d.
7928160The 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.
7929160Check statement aborted. Database contains deferred transactions.
7930160Mirroring must be removed from the database for this DBCC command.
7931160Database error: The FILESTREAM directory ID %.*ls for a partition was seen two times.
7932160Table 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.
7933160Table error: A FILESTREAM directory ID %.*ls exists for a partition, but the corresponding partition does not exist in the database.
7934160DBCC 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.
7935160Table 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.
7936160Table 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.
7937160Columnstore index has one or more missing column segments. Please run DBCC CHECKDB for more information.
7938160Table 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).
7939160Cannot detach database '%.*ls' because it does not exist.
7940160System databases master, model, msdb, and tempdb cannot be detached.
7941160Table 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).
7942100DBCC %ls scanning '%.*ls' table...
7943100Table: '%.*ls' (%d); index ID: %d, database ID: %d
7944100%ls level scan performed.
7945100- Pages Scanned................................: %I64d
7946100- Extents Scanned..............................: %I64d
7947100- Extent Switches..............................: %I64d
7948100- Avg. Pages per Extent........................: %3.1f
7949100- Scan Density [Best Count:Actual Count].......: %4.2f%ls [%I64d:%I64d]
7950100- Logical Scan Fragmentation ..................: %4.2f%ls
7951100Warning: 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.
7952100- Extent Scan Fragmentation ...................: %4.2f%ls
7953100- Avg. Bytes Free per Page.....................: %3.1f
7954100- Avg. Page Density (full).....................: %4.2f%ls
7955160Invalid SPID %d specified.
7956160Table 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.
7957100Cannot display the specified SPID's buffer; in transition.
7958160The specified SPID does not process input/output data streams.
7959160Columnstore index has one or more missing dictionaries. Please run DBCC CHECKDB for more info.
7960160An invalid server process identifier (SPID) %d or batch ID %d was specified.
7961160Object 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
7962160Invalid BATCHID %d specified.
7963160Database error: The file "%.*ls" is not a valid FILESTREAM LOG file in container ID %d.
7964100Repair: 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.
7965160Table 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).
7966100Warning: NO_INDEX option of %ls being used. Checks on non-system indexes will be skipped.
7967160Clustered 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.
7968100Transaction information for database '%.*ls'.
7969160No active open transactions.
7970100%hsOldest active transaction:
7971100 SPID (server process ID): %d%s
7972100 UID (user ID) : %d
7973160Clustered column store index '%.*ls' on table '%.*ls' has erroneous content in its mapping index.
7974100 Name : %.*ls
7975100 LSN : (%d:%d:%d)
7976160Nonclustered 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.
7977100 Start time : %.*ls
7978100 SID : %.*ls
7979100%hsReplicated Transaction Information:
7980100 Oldest distributed LSN : (%d:%d:%d)
7981160Clustered 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.
7982100 Oldest non-distributed LSN : (%d:%d:%d)
7983140User '%.*ls' does not have permission to run DBCC %ls for database '%.*ls'.
7984160System table pre-checks: Object ID %d. Page %S_PGID has unexpected page type %d. Check statement terminated due to unrepairable error.
7985160System 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.
7986160System 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.
7987160System 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.
7988160System table pre-checks: Object ID %d. Loop in data chain detected at %S_PGID. Check statement terminated due to unrepairable error.
7989160Checking identity information: current identity value '%.*hs'.
7991160Clustered columnstore index '%.*ls' on table '%.*ls' has a missing dictionary on column id %d and rowgroup id %d. Restore the data from a backup.
7992160Cannot shrink 'read only' database '%.*ls'.
7993100Cannot shrink file '%d' in database '%.*ls' to %u pages as it only contains %u pages.
7994100DBCC CheckDatabase on resource database will be skipped because user '%.*ls' does not have permission.
7995160Database '%.*ls': consistency errors in system catalogs prevent further DBCC %ls processing.
7996160Extended stored procedures can only be created in the master database.
7997160'%.*ls' does not contain an identity column.
7998160Checking identity information: current identity value '%.*hs', current column value '%.*hs'.
7999160Could not find any index named '%.*ls' for table '%.*ls'.