Thanks everyone..auto close was enabled and disabling it actually helped me solve the problem..

Thanks a lot everyone for your suggestions...I migrated the data by backing it up in sql 2000 and restoring with sql 2008. It worked fine. The only problem that I...