Completely removing a database!!!????

[SQLePO]

I am having problems using a peice of software called director. It creates itself a database in our SQL 2000 server when it is installed. The sa password has been changed and Director has crashed. We are now attempting to delete the database and re-install Director. How do I completely remove all references to the database so that another one with the same name can be created???

 

[osjohnm]

Hi SQLePO

Firstly click on Management in Enterprise Manager, then Current Activity, Process Info....

Then right click on all connections to the database and kill the processes, make sure all the processes are killed otherwise you won't be able delete the database.

Then right click on the database in EM and say delete or execute the following statment in query analyser:

DROP DATABASE database1

If you get an error about users then just kill the processes again and rather execute it through the analyser.

That will do it for you, when you remove a database all its data files and entries in the master database are completely removed from the hard drive.

John