rwsit
asked on
Could not find row in sysindexes for database ID 7, object ID 1, Run DBCC CHECKTABLE on sysindexes.
Received this error when I tried to attach an accounting db (which was accidentally on the SQL 2000 server when it got upgraded to SQL 2008).
Could not find row in sysindexes for database ID 7, object ID 1, Run DBCC CHECKTABLE on sysindexes.
I setup a VM with Win2000 server (w/SP4) & SQL 2000 (w/ SP4) & have copied the db over to a folder local within it.
Can anyone tell me how to attach this db to SQL 2000? We need to reference the information for an audit...
Help is greatly appreciated!!!
error602.jpg
Could not find row in sysindexes for database ID 7, object ID 1, Run DBCC CHECKTABLE on sysindexes.
I setup a VM with Win2000 server (w/SP4) & SQL 2000 (w/ SP4) & have copied the db over to a folder local within it.
Can anyone tell me how to attach this db to SQL 2000? We need to reference the information for an audit...
Help is greatly appreciated!!!
error602.jpg
ASKER
Thank you for the link - I had come across that prior to placing this question. I followed the instructions in that post and am still hitting a wall.
Is there no way to roll a db back from 2008 to 2000?
Is there no way to roll a db back from 2008 to 2000?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.experts-exchange.com/questions/21869935/Could-not-find-row-in-sysindexes-for-database-ID-7-object-ID-1-Run-DBCC-CHECKTABLE-on-sysindexes.html