> Now i get a message that the emerald database is suspect how do i clear this?
Make sure the emerald database device files are physically avaliable to
run instsupl.sql in your mssql\install directory.
run the new proc that it creates sp_reseststatus 'Emerald'
For more information about this list (including removal) go to: