Microsoft KB Archive/196770

= BUG: DBCC SHOWCONTIG Against Invalid Index ID Raises Msg 602 =

Article ID: 196770

Article Last Modified on 10/15/2002

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.