Knowledge Base

BUG: DBCC SHOWCONTIG Against Invalid Index ID Raises Msg 602

Article ID: 196770

Article Last Modified on 10/15/2002

Microsoft SQL Server 7.0 Standard Edition

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.

Additional query words: prodsql connection broken

Keywords: kbbug kbpending KB196770