Friday, March 18, 2011

Error Attaching Database

Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database'FR6DemoDB'. CREATE DATABASE is aborted.

This error is coming due to version mismatch of SQL Server. This particular error appears when you are trying to attach a SQL Server 2005 database in SQL Server 2000.

Data is created in SQL Server 2005 and you are trying to Restore/Attach this Data in SQL 2000, the above mentioned error will occur.

Please check your system and be sure that SQL Server 2005 is installed.

No comments:

Post a Comment