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.

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).