Move SQL Server Express .mdf file to SQL Server 2000 RRS feed

  • Question

  • Is this even possible?  I tried to move an existing Sql Server Express .mdf file to SQL Server 2000 by copying the .mdf file to the server's folder and then tried to attach it.  I get:

    Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID1.  Run DBCC CHECKTABLE on sysindexes.

    I realize that I'm moving back a version in SQL, however the structure of the database is very simple.  Does anyone know? 

    Even if I can just script the thing to SQL 2000 would be helpful, however the .mdf is a file within my ASP.Net site, and does not show up in my Microsoft SQL Server Management Studio Express under the appropriate SERVERNAME\SQLEXPRESS either, so I can't figure out how to script it out?

    Wednesday, February 14, 2007 12:53 AM