I am trying to attach a database but keep on getting the following error:
SQL Server 2008: Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
I did run the DBCC CHECKTABLE on sysindexes and it returned with 104 rows with no errors. I also ran DBCC CHECKDB --> but no errors.
I am not migrating the database or upgrading from the previous verison of SQL server.