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

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

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

Error Severity Description
7001 16 OPENXML flags parameter must be of data type int.
7002 16 OPENXML XPath must be of a string data type, such as nvarchar.
7003 16 Only one OPENXML column can be of type %ls.
7004 16 OPENXML does not support retrieving schema from remote tables, as in '%.*ls'.
7005 16 OPENXML requires a metaproperty namespace to be declared if 'mp' is used for another namespace in sp_xml_preparedocument.
7006 16 OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement.
7007 16 OPENXML encountered unknown metaproperty '%.*ls'.
7008 16 The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.
7009 16 OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument.
7101 16 You cannot use a text pointer for a table with option 'text in row' set to ON.
7102 20 SQL Server Internal Error. Text manager cannot continue with current statement.
7103 16 You cannot set option 'text in row' for table %s.
7104 16 Offset or size type is invalid. Must be int or smallint data type.
7105 22 Page %S_PGID, slot %d for text, ntext, or image node does not exist.
7106 16 You cannot update a blob with a read-only text pointer
7107 16 You can have only 1,024 in-row text pointers in one transaction
7108 22 Database ID, page, slot, link number is invalid. Run DBCC CHECKTABLE.
7116 16 Offset %d is not in the range of available text, ntext, or image data.
7117 16 Error reading large object (LOB) data from the tabular data stream (TDS).
7118 16 Only complete replacement is supported when assigning a large object (LOB) to itself.
7119 16 Attempting to grow LOB beyond maximum allowed size of <n>bytes.
7122 16 Invalid text, ntext, or image pointer type. Must be binary(16).
7123 16 Invalid text, ntext, or image pointer value %hs.
7124 16 The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.
7125 16 The text, ntext, or image pointer value conflicts with the column name specified.
7126 16 The text, ntext, or image pointer value references a data page with an invalid text, ntext, or image status.
7127 16 The text, ntext, or image pointer value references a data page with an invalid timestamp.
7128 16 The text, ntext, or image pointer value references a data page that is no longer allocated.
7130 16 %ls WITH NO LOG is not valid at this time. Use sp_dboption to set the 'select into/bulkcopy' option on for database '%.*ls'.
7133 16 NULL textptr (text, ntext, or image pointer) passed to %ls function.
7134 16 LOB Locator is not supported as text pointer when using UPDATETEXT/WRITETEXT to update/write a text column.
7135 16 Deletion length %ld is not in the range of available text, ntext, or image data.
7137 16 %s is not allowed because the column is being processed by a concurrent snapshot and is being replicated to a non-SQL Server Subscriber or Published in a publication allowing Data Transformation Services (DTS).
7138 16 The WRITETEXT statement is not allowed because the column is being replicated with Data Transformation Services (DTS).
7139 16 Length of text, ntext, or image data (%ld) to be replicated exceeds configured maximum %ld.
7140 16 Cannot 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.
7141 16 Must create orphaned text inside a user transaction.
7142 16 Must drop orphaned text before committing the transaction.
7143 16 Invalid locator de-referenced.
7144 16 A text/ntext/image column referenced by a persisted or indexed computed column cannot be updated.
7151 16 Insufficient buffer space to perform write operation.
7201 17 Could 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.
7202 11 Could not find server '%.*ls' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
7212 16 Could not execute procedure '%.*ls' on remote server '%.*ls'.
7213 20 Could not set up parameter for remote server '%.*ls'.
7214 16 Remote procedure time out of %d seconds exceeded. Remote procedure '%.*ls' is canceled.
7215 16 Could not execute statement on remote server '%.*ls'.
7221 16 Could not relay results of procedure '%.*ls' from remote server '%.*ls'.

Error Severity Description
7300 16 OLE DB error trace [%ls].
7301 16 Could not obtain a required interface from OLE DB provider '%ls'.
7302 16 Could not create an instance of OLE DB provider '%ls'.
7303 16 Could not initialize data source object of OLE DB provider '%ls'. %ls
7304 16 Could not create a new session on OLE DB provider '%ls'.
7305 16 Could not create a statement object using OLE DB provider '%ls'.
7306 16 Could not open table '%ls' from OLE DB provider '%ls'. %ls
7307 16 Could not obtain the data source of a session from OLE DB provider '%ls'. This action must be supported by the provider.
7308 16 OLE DB provider '%ls' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.
7310 16 Could not obtain the schema options for OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when it is used.
7311 16 Could not obtain the schema rowset for OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when it is used.
7312 16 Invalid use of schema and/or catalog for OLE DB provider '%ls'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.
7313 16 Invalid schema or catalog specified for provider '%ls'.
7314 16 OLE DB provider '%ls' does not contain table '%ls'. The table either does not exist or the current user does not have permissions on that table.
7315 16 OLE DB provider '%ls' contains multiple tables that match the name '%ls'.
7316 16 Could not use qualified table names (schema or catalog) with OLE DB provider '%ls' because it does not implement required functionality.
7317 16 OLE DB provider '%ls' returned an invalid schema definition.
7318 16 OLE DB provider '%ls' returned an invalid column definition.
7319 16 OLE DB provider '%ls' returned a '%ls' index '%ls' with incorrect bookmark ordinal %d.
7320 16 Could not execute query against OLE DB provider '%ls'. %ls
7321 16 An error occurred while preparing a query for execution against OLE DB provider '%ls'. %ls
7322 16 A failure occurred while giving parameter information to OLE DB provider '%ls'. %ls
7323 16 An error occurred while submitting the query text to OLE DB provider '%ls'. %ls
7324 16 A failure occurred while setting parameter properties with OLE DB provider "%ls" for linked server "%ls".
7325 16 Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access remote object '<Object Name>'.
7326 16 An error occurred while retrieving the query text from OLE DB provider "%ls" for linked server "%ls".
7327 16 A failure occurred while retrieving parameter information to OLE DB provider "%ls" for linked server "%ls".
7330 16 Could not fetch a row from OLE DB provider '%ls'. %ls
7331 16 Rows from OLE DB provider '%ls' cannot be released. %ls
7332 16 Could not rescan the result set from OLE DB provider '%ls'. %ls
7333 16 Could not fetch a row using a bookmark from OLE DB provider '%ls'. %ls
7339 16 OLE DB provider '%ls' for linked server '%ls' returned invalid data for column '%ls.%ls'.
7340 16 Could not create a column accessor for OLE DB provider '%ls'. %ls
7341 16 Could not get the current row value of column '%ls.%ls' from the OLE DB provider '%ls'. %ls
7342 16 Unexpected NULL value returned for column '%ls.%ls' from the OLE DB provider '%ls'. This column cannot be NULL.
7343 16 OLE DB provider '%ls' could not %ls table '%ls'. %ls
7344 16 OLE DB provider '%ls' could not %ls table '%ls' because of column '%ls'. %ls
7345 16 OLE DB provider '%ls' could not delete from table '%ls'. %ls
7346 16 Could not get the data of the row from the OLE DB provider '%ls'. %ls
7347 16 OLE DB provider '%ls' returned an unexpected data length for the fixed-length column '%ls.%ls'. The expected data length is %ls, while the returned data length is %ls.
7348 16 OLE DB provider '%ls' could not set range for table '%ls'.%ls
7349 16 OLE DB provider '%ls' could not set range for table '%ls' because of column '%ls'.%ls
7350 16 Could not get the column information from the OLE DB provider '%ls'.
7351 16 OLE DB provider '%ls' could not map ordinals for one or more columns of object '%ls'.
7352 16 OLE DB provider '%ls' supplied inconsistent metadata. The object '%ls' was missing expected column '%ls'.
7353 16 OLE DB provider '%ls' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
7354 16 OLE DB provider '%ls' supplied invalid metadata for column '%ls'. %ls
7355 16 OLE DB provider '%ls' supplied inconsistent metadata for a column. The name was changed at execution time.
7356 16 OLE DB provider '%ls' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
7357 16 Could not process object '%ls'. The OLE DB provider '%ls' indicates that the object has no columns.
7358 16 Could not execute query. The OLE DB provider '%ls' did not provide an appropriate interface to access the text, ntext, or image column '%ls.%ls'.
7359 16 The OLE DB provider '%ls' reported a schema version for table '%ls' that changed between compilation and execution.
7360 16 Could not get the length of a storage object from the OLE DB provider '%ls' for table '%ls', column '%ls'.
7361 16 Could not read a storage object from the OLE DB provider '%ls', for table '%ls', column '%ls'.
7362 16 The OLE DB provider '%ls' reported different meta data at run time for table '%ls' column '%ls'.
7365 16 Could not obtain optional metadata columns of columns rowset from the OLE DB provider '%ls'.
7366 16 Could not obtain columns rowset from OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when used.
7367 16 The OLE DB provider '%ls' supports column-level collation, but failed to provide metadata column '%ls' at run time.
7368 16 The OLE DB provider '%ls' supports column-level collation, but failed to provide collation data for column '%ls'.
7369 16 The OLE DB provider '%ls' provided invalid collation. %ls.
7370 16 One or more properties could not be set on the query for OLE DB provider '%ls'. %ls
7371 16 One or more properties could not be set on the table for OLE DB provider '%ls'.
7372 16 Cannot get properties from OLE DB provider '%ls'.
7373 16 Could not set the initialization properties for the OLE DB provider '%ls'.
7374 16 Could not set the session properties for the OLE DB provider '%ls'.
7375 16 Could not open index '%ls' on table '%ls' from OLE DB provider '%ls'. %ls
7376 16 Could not enforce the remote join hint for this query.
7377 16 Cannot specify an index or locking hint for a remote data source.
7378 16 The update/delete operation requires a unique key or a clustered index on the remote table.
7379 16 OLE DB provider '%ls' returned an unexpected '%ls' for the decimal/numeric column '%ls.%ls'. The expected data length is '%ls', while the returned data length is '%ls'.
7380 16 Table-valued parameters are not allowed in remote calls between servers.
7390 16 The requested operation could not be performed because the OLE DB provider '%ls' does not support the required transaction interface.
7391 16 The operation could not be performed because the OLE DB provider '%ls' was unable to begin a distributed transaction.
7392 16 Could not start a transaction for OLE DB provider '%ls'.
7393 16 OLE DB provider '%ls' reported an error aborting the current transaction.
7394 16 OLE DB provider '%ls' reported an error committing the current transaction.
7395 16 Unable to start a nested transaction for OLE DB provider '%ls'. A nested transaction was required because the XACT_ABORT option was set to OFF.
7396 16 Varchar(max), nvarchar(max), varbinary(max) and large CLR type data types are not supported as return value or output parameter to remote queries.
7397 16 Remote function returned varchar(max), nvarchar(max), varbinary(max) or large CLR type value which is not supported.
7399 16 OLE DB provider '%ls' reported an error. %ls
7401 16 Cannot create OLE DB provider enumeration object installed with SQL Server. Verify installation.
7403 16 Could not locate registry entry for OLE DB provider '%ls'.
7404 16 The server could not load DCOM.
7405 16 Heterogeneous 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.
7409 16 Could 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.
7410 16 Remote access not allowed for Windows NT user activated by SETUSER.
7411 16 Server '%.*ls' is not configured for %ls.
7412 16 OLE DB provider "%ls" for linked server "%ls" returned message "%ls".
7413 16 Could not perform a Windows NT authenticated login because delegation is not available.
7414 16 Invalid number of parameters. Rowset '%ls' expects %d parameter(s).
7415 16 Ad hoc access to OLE DB provider '%ls' has been denied. You must access this provider through a linked server.
7416 16 Access to the remote server is denied because no login-mapping exists.
7417 16 GROUP BY ALL is not supported in queries that access remote tables if there is also a WHERE clause in the query.
7418 16 Text, image, or ntext column was too large to send to the remote data source due to the storage interface used by the provider.
7419 16 Lazy schema validation error. Linked server schema version has changed. Re-run the query.
7420 16 Remote access is not supported for transaction isolation level "%ls".
7421 10 Cannot fetch the rowset from OLE DB provider "%ls" for linked server "%ls". %ls.
7422 16 OLE DB provider "%ls" for linked server "%ls" returned an invalid index definition for table "%ls".
7423 16 The '%ls' OLE DB provider for the '%ls' linked server returned an invalid CLR type definition for the '%ls' table.
7424 10 OLE DB provider "%ls" for linked server "%ls" returned "%ls" with data type "%ls", which should be type "%ls".
7425 10 OLE DB provider "%ls" for linked server "%ls" returned an incorrect value for "%ls", which should be "%ls".
7426 10 OLE DB provider "%ls" for linked server "%ls" returned "%ls" without "%ls" being supported.
7427 10 OLE DB provider "%ls" for linked server "%ls" returned "%ls" for "%ls" during statistics gathering.
7428 10 OLE DB provider "%ls" for linked server "%ls" supported the schema lock interface, but returned "%ls" for "%ls".
7429 10 %hs SQL Server Remote Metadata Gather Time for Table %s.%s:%hs, CPU time = %lu ms, elapsed time = %lu ms.
7430 16 Out-of-process use of OLE DB provider "%ls" with SQL Server is not supported.
7431 16 Unable to delete OLE DB parameter properties.
7432 16 Heterogeneous queries and use of OLEDB providers are not supported in fiber mode.
7433 10 OLE 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.
7435 16 The OLE DB provider "%ls" for linked server "%ls" returned unexpected NULL pointer for string column "%ls.%ls".
7436 16 The 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.
7437 16 Linked servers cannot be used under impersonation without a mapping for the impersonated login.
7438 16 The 32-bit OLE DB provider "%ls" cannot be loaded in-process on a 64-bit SQL Server.

Related Articles :