Is this a production database? When ever you touch a production database, read read read read and understand what you are doing and how you can do it.

Just read carefully, the last post from dbasan and do again.