Skip to content

Instantly share code, notes, and snippets.

@freemanirl

freemanirl/drop_db.sql

Created July 16, 2018 15:50
Show Gist options
  • Save freemanirl/b88503f5fad824cd9d98dbcb7bf837dc to your computer and use it in GitHub Desktop.
Save freemanirl/b88503f5fad824cd9d98dbcb7bf837dc to your computer and use it in GitHub Desktop.
Download ZIP
Drop DB++
Raw
drop_db.sql
USE [master];
DECLARE @dbName varchar(64) = 'TimeZoneDB'
DECLARE @kill varchar(8000) = '';
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'
FROM sys.dm_exec_sessions
WHERE database_id = db_id(@dbName)
SET @kill = @kill + 'Drop Database ' + @dbName
EXEC(@kill);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment