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!!!