I detached a database in SQL 2005 today, doing so using sp_detach.
The operation should have been pretty instant, but after a few minutes I realised something was up.
The database was stuck 'in transition', or so it appeared to Management Studio. I contemplated what to do. I wanted to avoid restarting the service and leaving the db in an inconsistent state, and hence googled the following...
Error 952 Database is in Transition
As it happens, the database isn't stuck at all, it's just Management Studio thinks it is.
The solution. RESTART MANAGEMENT STUDIO. Argh!