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