InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:53:41 GMT20http://www.sqlservercentral.com/Forums/Topic1215850-391-1.aspxi check all process but no process shown in sysprocesses and Sp_who/sp_who2.I had check database id from.select * from sys.databasesthenselect * from sys.sysprocesses WHERE dbid = 84SELECT * FROM sys.dm_exec_requests WHERE database_id = 84select * from sys.dm_tran_locks where resource_database_id=84After that you will get procees id.then kill corresponding session and check database status.Mon, 14 Jan 2013 02:31:48 GMTdineshvishehttp://www.sqlservercentral.com/Forums/Topic1215850-391-1.aspxclose your mangement studio and start again . I had a same issue in pastSat, 03 Dec 2011 08:46:42 GMTsalumhttp://www.sqlservercentral.com/Forums/Topic1215850-391-1.aspxI am getting while using database. I was trying to take databse in OFFLine.Msg 952, Level 16, State 1, Line 1Database abc is in transition. Try the statement later.Sat, 03 Dec 2011 08:45:26 GMTSatya_0000