Article ID: 277547 - View products that this article applies to.
This article was previously published under Q277547
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57899 (SQLBUG_70)
Table corruption errors may occur on index pages under the following conditions:
NOTE: The issue does not occur if there is a clustered index on the table in question.
Server: Msg 8951, Level 16, State 1, Line 1
Table Corrupt: Table 'table_name' (ID 1941581955). Missing or invalid key in index 'index_name' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:365:0) identified by (RID = (1:365:0) ) has index values (store_number = 1211 and ssn = '440921916' and date_worked = Feb 7 2000 12:00AM?|??WeG and clock_in_time = '16:53' and clock_out_time = '19:08').
To work around this problem, rebuild the affected index by using one of the following methods:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799For more information, contact your primary support provider.
(http://support.microsoft.com/kb/274799/ )INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0