attach problem to new sql server

I cannot attach mdf files which i have substituted and reloaded sQl 2000 and 2005 after formatting my pc
both of the sales gives error
mdfs which i formatted and attached without any problem, now make a fuss
i thought that there may be problems with my files and i attached from my elder substitutes or from any other sample which i
had downloaded from net, but still i have the same warning
i have formatted my pc several times and tested them
for instance i tried to load only the sQl 2000 and to attach the mdfs which i have generated with sQl2000
in case there is a superposition but i still have the same warning

do you have any idea ??

the error message is below;

TITLE: Microsoft SQL Server Management Studio
----------

Attach database failed for Server 'ASUS'. (Microsoft.SqlServer.Smo)

----------
ADDITIONAL INFORMATION:

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

----------

Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'yorumlat'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

I think you are trying to attach .mdf file for the database that create in SQL Server 2005 to a database in SQL Server 2000.

If this is the case, then please know that this is not supported.

Good luck.

|||

no... I'm trying to attach .mdf file that create in sql server 2000 to a database in sql server 2000...

|||

So, it seems to me your database is corrupted.

Try to attach it on another server in another machine, you get the same error.

Good luck.