Interview Question in Sql Server 2000


 

Interview Question :: How to attach a database by using attach command in EM(enterprise manager)

i hve sql server 2000 installed on my pc...i want to load a database by using the mdf file but when i m trying to execute the attach command it is showing an error that "could find row in sysindexes for database id 9,object id 1,run dbcc chktables in sysindexes"....how can i rectify this reeor and load the database from mdf file plase provide detailed information
by ksk