Attaching MDF to older version SQL Server Enterprise Manager

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cirene - 21 May 2008 01:13 GMT

I create an ASP.NET web application using Visual Studio 2008. I created a
SQL Database thru here as well.

I copied the MDF over to the server, which is running SQL Server Enterprise
Manager (v 8). When I try to attach the MDF I get...

Microsoft SQL-DMO (ODBC SQL State: HY000)
Error 602: Could not find row in sysindexes for database ID 13, object ID 1,
index ID 1. Run DBCC CHECKTABLE on sysindexes.

What does this mean? Is this because the db was created in a newer version?

Reply to this Message

Mark Rae [MVP] - 21 May 2008 01:43 GMT

> Microsoft SQL-DMO (ODBC SQL State: HY000)
> Error 602: Could not find row in sysindexes for database ID 13, object ID
> 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
>
> What does this mean?

Plenty of examples of this on Google, with various suggestions:
http://www.google.co.uk/search?sourceid=navclient&hl=en-GB&ie=UTF-8&rlz=1T4GZEZ_
en-GBGB252GB252&q=%22Could+not+find+row+in+sysindexes%22

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...