BUG: DBCC SHOWCONTIG Against Invalid Index ID Raises Msg 602 (196770)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q196770
BUG #: 53335 (SQLBUG_70)

SYMPTOMS

If an invalid (non-existent) index ID is specified as input to DBCC SHOWCONTIG, a Msg 602 occurs and the client connection to SQL Server is broken:
Msg 602, Level 21, State 13, Server SQLSRV1, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find row in
sysindexes for database ID 5, object ID 117575457,
index ID 3. Run DBCC CHECKTABLE on sysindexes.

Connection Broken

WORKAROUND

To successfully run DBCC SHOWCONTIG, resubmit the command with a valid index ID.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.
Modification Type:MajorLast Reviewed:10/15/2002
Keywords:kbBug KB196770
©2002 Microsoft Corporation. All rights reserved.