Msg 924, Level 14, State 1, Line 27
Database '' is already open and can only have one user at a time.
Msg 3702, Level 16, State 4, Line 9
Cannot drop database "" because it is currently in use.
The next step you took, used the
It returned you all processes but you don't see the database name in the list. Means no process is running. You tried to drop the database again but received the same error as given above.
Now you used below query to get more information and hoping it should return you the processid so you can kill it and then drop the database.
Select * from sys.sysprocesses where DB_Name(dbid)='YourDBName'
This query does not return you any record. That is disappointing. It is not letting us drop the database and complaining process is running on it and when we try to find , it can't find it.
SELECT request_session_id FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID('YourDBName')
drop database [YourDatabaseName]