thanks for the replay, actually i made a mistake saying that the mdf file is of Sql server 2000, the mdf file am trying to attach is of sql 7.0...

Thanks for the information :-), Is there any stored procedure in sql which can be used to update the mdf files to the latest version,those stored procedure which i can...

Yes i tried it it is working fine, but the client system is having only 2008 and there is an application which accepts old mdf file and update it to...

i tryed

"sp_attach_db 'abcd',

'D:\Old database\abcd.mdf',

'D:\Old database\abcd_log.ldf'"

GO

Then too it dint work, if i attach mdf of 2000 to 2005 it works and then from 2005 to 2008 also it works...