FIX: Attempt to Delete a Row May Raise Error 631 (193992)
The information in this article applies to:
This article was previously published under Q193992
BUG #: 17622 (SQLBUG_65)
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 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base: 197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a 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.
| Modification Type: | Major | Last Reviewed: | 3/14/2006 |
|---|
| Keywords: | kbBug kbfix kbSQLServ650sp5fix KB193992 |
|---|
|