BUG: DBCC SHOWCONTIG Against Invalid Index ID Raises Msg 602

ID: Q196770

The information in this article applies to:

Microsoft SQL Server version 7.0

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 : kbbug7.00
Version : WINNT:7.0
Platform : winnt
Issue type : kbbug