Cannot drop SQL Server database
I have an ASP.NET page that connects to a SQL Server 2000 database. I want to delete the database and I get this error:
Error 3702: Cannot drop the database 'db' because it is currently in use.
I have made sure to call .Close() on all my connections and .Dispose() on all the database objects. The only way I can delete the database is to go to Task Manager and End Task on aspnet_wp.exe
It worries me the database is locked even after I close the page and the development environment.