• Issue is still in same state.

    1. DBCC OPENTRAN is showing this results....

    Transaction information for database 'master'.

    Oldest active transaction:

    SPID (server process ID): 56

    UID (user ID) : -1

    Name : ChangeDbState

    LSN : (628:376:1)

    Start time : Apr 26 2012 10:49:29:140AM

    SID : 0x01050000000000051500000079e3fc5354190e29be043e32823f0000

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    2. DBCC INPUTBUFFER (56)

    DBCC CheckDB (QFM162RES14 , REPAIR_ALLOW_DATA_LOSS)

    3. KILL 56

    SPID 56: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

    Thank You