How drop a database after connecting new one

Question

i am tried drop database after connecting new database.I want to drop old database, there is message appeared"cannot drop database because it is currently in use".I connected new database, then why i cannot drop database?

Suthish Nair · Answer

No Sam am talking about SQL Server user and other session activities.

Sam Hobbs · Answer

Note that Microsoft advises against killing processes. It should not be done by design; it should be done only in exceptional conditions.

Suthish Nair · Answer

Abdu You need to release or kill all user sessions and all threads before droping the database.

Soft Corner · Answer

Hi Can you show your code here might be you have open connection in code & if that so close existing one and reopen your connection.