InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 16:33:32 GMT20http://www.sqlservercentral.com/Forums/Topic420997-1083-1.aspxYour code lis fine, but it seems like you mdf file is corrupted.Do you have any backup of the database? If yes try to restore it and run DBCC CHECKDB or DBCC CHECKTABLE (sysobjects) with ALL_ERRORMSGSMarkusMon, 12 Nov 2007 05:43:37 GMTMarkusBhttp://www.sqlservercentral.com/Forums/Topic420997-1083-1.aspxhow to attach databse file in sql server 2000.I have try code like this.....................execute sp_attach_db @dbname='MyInsurance', @filename1='G:\Insurance\App_Data\Database.mdf', @filename2='G:\Insurance\App_Data\Database_log.ldf' then error occurs like this.........................Server: Msg 602, Level 21, State 50, Line 1Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Connection Broken---------------------------------------------plz help me, for successful attachment database....waiting Thanks:Mon, 12 Nov 2007 05:23:54 GMTbm_007