One of our SQL 2005 database started to give us "Database is in transition...Error 952". We were trying to Take the DB offline when this problem occurred. Restarting SQL service did not help us. We were unable to do anything with this database as we were unable to obtain any locks. What resolved the problem? Re-starting manamgement studio on client machine. Go Figure!
View Complete Post