Advertisement
Guest User

Untitled

a guest
Feb 27th, 2015
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. Use master;
  2. ALTER database [databasename] set offline with ROLLBACK IMMEDIATE;
  3. DROP database [databasename];
  4.  
  5. Drop database [databasename] ; //deletes the database completely, including the ldf and mdf's.
  6.  
  7. ALTER DATABASE [databasename] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
  8. DROP DATABASE [databasename] ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement