Problems while attaching a database in SQLServer 2000

Dear all,

I recive a error when i attaching a database in sqlserver 2000. The error is :-

An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.

Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)

Are you attaching a database in SQL Server 2000 from a SQL Server 2005 Express? This won't work.|||Not in Express edition. I am trying it on Sql Server 2005 Enterprise Edition..|||

Hi Deepak,

could you post the t-sql used !!! and post Errors from SQL Error Logs too!!

Hemantgiri S. Gowami

|||

I recive a error when i attaching a database in sqlserver 2000. The error is :-

An exception occurred while executing a T-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindex for databases ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.

Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)

|||

How I can solve the error when attaching a database in sqlserver 2000.

Could not find row in sysindex for databases ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexs.

Could not open new database 'ABC'. Create Database is aborted. (Microsoft SQL Server, Error: 602)