Microsoft KB Archive/937758

= You receive an error message when you try to attach a SQL Server 2005 database in SQL Server 2000 =

Article ID: 937758

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Workgroup Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Standard Edition

-



SYMPTOMS
When you try to attach a Microsoft SQL Server 2005 database in SQL Server 2000, you receive the following error message:

Server: Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.



CAUSE
This behavior occurs because attaching SQL Server 2005 databases in SQL Server 2000 is not supported.



STATUS
This behavior is by design.



Steps to reproduce the behavior

 * 1) Create a database in SQL Server 2005.
 * 2) Detach this database in SQL Server 2005.
 * 3) Attach this database in SQL Server 2000.

Keywords: kbtshoot kbexpertiseadvanced kbsql2005engine kbprb KB937758

-

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

© Microsoft Corporation. All rights reserved.