FIX: Attempt to Delete a Row May Raise Error 631

• Microsoft SQL Server version 6.5

SYMPTOMS

A DELETE statement that causes a consolidation of index pages may report error 631:

Msg 631, Level 21, State 2 The length of 24 passed to delete row routine for the row at offset 32 is incorrect on the following page: Page pointer = 0x11cf000, pageno = 634, status = 0x0, objectid = 1744009244, indexid = 1 The SQL Server is terminating this process.

WORKAROUND

To work around this problem, do either of the following:

• Re-create the index with a different fill factor.
  
  -or-



• Drop and re-create the index.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

MORE INFORMATION

When consolidating an index page, under very limited conditions, the length of a row may be incorrectly calculated by the engine.

Additional query words:

Keywords          : kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 4, 1999