Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Deleting a database??????
- Thread starter SQLePO
- Start date
Hi
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
John
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
John
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question