attach database Error

• nareathan

  SSC Enthusiast

  Points: 109

  More actions

  June 3, 2008 at 10:21 pm

  #208006

  [font="Arial"]

  in SQL Server 2000 when i attach have Error. it show message like this.

  Could not find row in sysindexes for database ID 7, object ID 1, Run DBCC CHECKTABLE on sysindexes.

  Any help or suggestion would be much appreciated!

  [/font]

• the__t

  Hall of Fame

  Points: 3260

  More actions

  June 4, 2008 at 6:46 am

  #824125

  Did this database already exist on SQL 2005 before you tried attaching it in 2000?

  Actually, just as a first question, is this database "Adventure Works", or a "real" database?

  "Got no time for the jibba jabba!"
  -B.A. Baracus