SQL Server: "Error 952 Database is in Transition"
Hello All, Today I have just faced this problem when I was trying to log-in to a database. I can't even execute sp_who command to view who is doing wrong. Then I execute below command to see what was happening with my instance. SELECT r . scheduler_id , r . cpu_time , r . session_id , r . command Command , t . text SQL_Statment , r . blocking_session_id Blocking_Session_ID , r . total_elapsed_time / 1000 Total_Elapsed_Time_Seconds , r . cpu_time CPU_Time , s . login_name Login_Name , s . [host_name] [Host_Name] , s . [program_name] [Program_name] , s . memory_usage Memory_Usage , r . status [Status] , db_name ( r . database_id ) Database_Name , r . wait_t...