Error 7901

Severity Level 16

Message Text

Page %Id was expected to be the first page of a TEXT/IMAGE value.

Explanation

This error indicates one of these two conditions:

• The page pointer for a text or image column has been corrupted and is referencing a data page instead of a text or image page.
• The first page of the text or image chain for a given column has not been correctly marked as a text or image page.

Action

Verify the consistency of the database by running DBCC CHECKDB and DBCC NEWALLOC.

If there are no other reported problems and you know which rows in the table are the cause of the problem, follow these steps:

1. Attempt to create a new table that contains the offending rows. This can be done by running a SELECT statement with the INTO clause and restricting the query by using a WHERE clause so that only the offending rows are inserted into the new table.
2. Verify that the new table contains the appropriate data.
3. Run DBCC checktable against the temporary table.
4. If no errors are reported in step 3, delete the offending rows from the original table.
5. Insert the rows from the temporary table back into the original table.
6. Drop the temporary table.
7. Run DBCC checktable against the original table.
8. If the problem persists, delete and re-insert the offending rows.

If you cannot determine which rows are causing the error, take the following steps:

1. Attempt to create a copy of the table by running a SELECT statement with the INTO clause.
2. Verify that the new table contains the appropriate data.
3. Run DBCC checktable against the new table.
4. If the DBCC in step 3 did not report any errors, drop the original table.
5. Rename the new table by running:

   sp_rename new_table_name name_of_original_table

6. Run DBCC checktable against the original table.

If the problem persists, contact your primary support provider.

Because of their potentially large size, text and image data in SQL Server is stored in a page chain independent of the page chain for the actual table. The only information stored in the table regarding a text or image column is the page number of the first page in the text or image chain. For more information, see the Text and Image Manipulation topic in the Microsoft SQL Server Transact-SQL Reference.