Today I had detached a database in SQL SERVER 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.
solution. RESTART MANAGEMENT STUDIO.
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.
solution. RESTART MANAGEMENT STUDIO.
