Drop database fails because of aspnet_wp.exe

Hey everyone.

I'm having some problems dropping a database because the aspnet_wp.exe process is accessing it. Whenever I try to drop it, I get an error stating that the database is being used. If I access the task manager and end the aspnet_wp.exe process manually and then retry the database drop it works... :\

Any help? Thaks in advance,

Sérgio

You can't drop the database because it is using by some .NET application. aspnet_wp.exe is a worker process in which .NET runs code, you can take a look at this article:

http://www.xefteri.com/articles/show.cfm?id=14

|||A connection is being kept open by an asp.net application. Either it forgot to close the connection after it was rendering a page, or (more likely), the connection was kept open in the connection pool.