Post reply

Error

  • December 3, 2011 at 8:45 am

    #263936

    I am getting while using database. I was trying to take databse in OFFLine.

    Msg 952, Level 16, State 1, Line 1

    Database abc is in transition. Try the statement later.

  • December 3, 2011 at 8:46 am

    #1416310

    close your mangement studio and start again . I had a same issue in past

    java[/url]

  • January 14, 2013 at 2:31 am

    #1576793

    i check all process but no process shown in sysprocesses and Sp_who/sp_who2.

    I had check database id from.

    select * from sys.databases

    then

    select * from sys.sysprocesses WHERE dbid = 84

    SELECT * FROM sys.dm_exec_requests WHERE database_id = 84

    select * from sys.dm_tran_locks where resource_database_id=84

    After that you will get procees id.

    then kill corresponding session and check database status.

  • June 2, 2013 at 11:45 pm

    #1620388

    .

  • June 3, 2013 at 12:18 am

    #1620394

    Please try to Stop and Start sql server service using management studio to resolved this issue...

  • June 3, 2013 at 1:26 am

    #1620408

    Restart the SQL Server

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply