I used the sp_detach - only instead of writing the sp_detach in query analyzer, I did it by right clicking on the database and clicking on detach in enterprise...