This morning I was trying to restore a backup copy of our production
environment to our test environment when the network had a hiccup. This has
left my test database in a 'loading' state. I don't need the existing
database since it is a test database, but I can't even delete it. When
running sp_helpdb, it does not show up in the list of databases, although I
can see it in enterprise manager. Also, it says that it is not part of the
data collection.

I know there is a way to remove this database, but for the life of me I
can't remember.

Would you please pass on any suggestions?

Thanks in advance,

Darlene
MS Sql Server LazyDBA home page