detach database forcefully

[Guest]

Hi

I had developed a setup project which attaches a database while installing it & detaches it when uninstalled. Installation works fine. While uninstalling it throws an exception:"Cannot detach the database ,it is currently in use"
How do I forcefully detach a database (even though it is connected to any appln)

Thank
Priya

 

[William Ryan eMVP]

Priya, you could include this in a proc or run this as a job which then
detaches the db.

http://www.knowdotnet.com/articles/killallconnections.html

HTH,

Bill

Hi,

I had developed a setup project which attaches a database while installing

it & detaches it when uninstalled. Installation works fine. While
uninstalling it throws an exception:"Cannot detach the database ,it is
currently in use".