> 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
sql server.
run instsupl.sql in your mssql\install directory.
run the new proc that it creates sp_reseststatus 'Emerald'
ciao,
Peter
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart