Post
Ask Question

Forcefully Rename Or Delete Database

 First Set database in single user mode after that Rename database.
  1. alter database SOURCES   
  2. set single_user  
  3. with rollback immediate   
  4. go   
  5.   
  6. ALTER DATABASE SOURCES  
  7. MODIFY NAME =SOURCES_COLDEX  
  8. GO  
  9. ALTER DATABASE SOURCES_COLDEX  
  10. SET MULTI_USER  
  11. GO  
First Set database in single user mode after that Delete database. 
  1. ALTER DATABASE SOURCES  
  2. SET SINGLE_USER --or RESTRICTED_USER  
  3. WITH ROLLBACK IMMEDIATE;  
  4. GO  
  5. DROP DATABASE SOURCES;  
  6. GO