Error 602 in database in MSSQL

Asked By Hiram B Nunn 35 points N/A Posted 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 

• Status: Open
• Question Views: 898
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Clare Moui 0 points N/A #184448

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

About Clare Moui

Questions
0

Answers
100

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 01/15/2015
• Question Category: MS SQL Server