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.