Skip to content

Instantly share code, notes, and snippets.

@socketbox

socketbox/drop_db_mssql2008.sql

Created November 11, 2014 16:13
Show Gist options
  • Save socketbox/aae5342cc9e04d8be0cc to your computer and use it in GitHub Desktop.
Save socketbox/aae5342cc9e04d8be0cc to your computer and use it in GitHub Desktop.
Download ZIP
Drop database in MS SQL Server 2008
Raw
drop_db_mssql2008.sql
USE master;
ALTER DATABASE [db_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [db_name];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment