Cannot drop database “xxxxx” because it is currently in use.

Problem:

Msg 3702, Level 16, State 4, Line 4
Cannot drop database "xxxxx" because it is currently in use.

Solution:

When you have tried everything to drop the database but nothing works.

• Stop the SQL Server service.
• Manually remove the data files from drive.
• Restart the SQL Server service.
• Delete database.