SQL Server Helper - Error Message 7001 to 7500

Tip of the Day : SQL Server Numeric Data Types

Error Messages

Home > Tips & Tricks > Error Messages 7001 to 7500

SQL Server Error Messages - Errors 7001 to 7500

SQL Server Error Message - 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.