In Query Analyzer run sp_databases to check if the database FIFO realy exist. You
must run the command sp_dbremove in the master database. Otherwise do a refresh
in Enterprise Manager under databases to see if the status of the database has
changed or does not exist anymore.
I get the following message when running sp_dbremove:
The database 'FIFO' does not exist. Use sp_helpdb to show available
You can try to run sp_dbremove in Query Analyzer to drop the database that
I have a database which is shown as loading in the Enterprise Mananger
Console Tree. I aborted a restore yesterday and the database has not yet
recovered. I wish to delete, recreate, and then restore the database. How
can I drop the database to begin this process?