The information in this article applies to:
BUG #: 18478 (SQLBUG_65) SYMPTOMSExecuting DBCC CHECKTABLE(sysindexes) may cause SQL Server to stop responding when there is a row on an index page owned by sysindexes but that page does not actually exist. CAUSEThe index page pointers in the index structure show a row that there is no page for. This can occur when the dropping of an index did not complete successfully. STATUSMicrosoft has confirmed this to be a problem in SQL Server version 6.5. MORE INFORMATION
Because DBCC CHECKDB includes running DBCC CHECKTABLE(sysindexes), it may also cause SQL Server to stop responding. DBCC NEWALLOC may report error 2540, but you can remove these errors by running DBCC FIX_AL. Additional query words: hang hangs hung
Keywords : kbbug6.50 |
Last Reviewed: March 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |