N/APosted on - 01/13/2015
Hello! Please help! I am trying to upload database from old computer to the new one and I see some weird error that I haven't seen before: Error 602: Could not find row in sysindex for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. What does this mean? what is DBCC CHECKTABLE? How to fix it? Thank you in advance
Error 602 in database in MSSQL
You have not mentioned the version of SQL server. This type of error generally comes when you upload the database in lower version. If you have created the database in SQL 2008 R2 , Then it will not get uploaded in SQL 2008 R1. The higher database doesn’t get uploaded in lower version of SQL. Please check the version of SQL and then upload the database.
The other problem for this type of error can be Stored procedures. Stored procedures references must not be corrupted. Try to recreate the stored procedures and execute DBCC CHECKTABLE