• 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.