How to restore Suspect database (SQL 2005)

NOTE: This script should not be run directly on Production Databases. You should try to run it on a test environment under the supervision of a DBA and then move to PROD.