SQL Server Errors or Failures from Error: 7001 to Error: 7119
Error: 7001, Severity: 16, OPENXML flags parameter must be of data type int.
Error: 7002, Severity: 16, OPENXML XPath must be of a string data type, such as nvarchar.
Error: 7003, Severity: 16, Only one OPENXML column can be of type %ls.
Error: 7004, Severity: 16, OPENXML does not support retrieving schema from remote tables, as in ‘%.*ls’.
Error: 7005, Severity: 16, OPENXML requires a metaproperty namespace to be declared if ‘mp’ is used for another namespace in sp_xml_preparedocument.
Error: 7006, Severity: 16, OPENXML encountered a problem identifying the metaproperty namespace prefix. Consider removing the namespace parameter from the corresponding sp_xml_preparedocument statement.
Error: 7007, Severity: 16, OPENXML encountered unknown metaproperty ‘%.*ls’.
Error: 7008, Severity: 16, The OPENXML EDGETABLE is incompatible with the XMLTEXT OVERFLOW flag.
Error: 7009, Severity: 16, OPENXML allows only one metaproperty namespace prefix declaration in sp_xml_preparedocument.
Error: 7101, Severity: 16, You need an active user transaction in order to use text pointers for a table with the option “text in row” set to ON.
Error: 7102, Severity: 20, Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE.
Error: 7104, Severity: 16, Offset or size of data type is not valid. Data type must be of type int or smallint.
Error: 7105, Severity: 22, The 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.
Error: 7106, Severity: 16, Internal error: An attempt was made to update a LOB data type using a read-only text pointer.
Error: 7107, Severity: 16, You can have only 1,024 in-row text pointers in one transaction
Error: 7108, Severity: 22, Database ID %d, page %S_PGID, slot %d, link number %d is invalid. Run DBCC CHECKTABLE.
Error: 7116, Severity: 16, Offset %d is not in the range of available LOB data.
Error: 7117, Severity: 16, Error reading large object (LOB) data from the tabular data stream (TDS).
Error: 7118, Severity: 16, Only complete replacement is supported when assigning a large object (LOB) to itself.
Error: 7119, Severity: 16, Attempting to grow LOB beyond maximum allowed size of %I64d bytes.
This is applicable on below versions of SQL Server
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.