Drop and create database with kill processes

DropAndCreateWithKill.sql

USE master
GO
-- Creating the ModernApiDB
DECLARE @dbname sysname
SET @dbname = 'MY_DB'

DECLARE @spid int
SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname)
WHILE @spid IS NOT NULL
BEGIN
EXECUTE ('KILL ' + @spid)
SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid > @spid
END
GO

DROP DATABASE MY_DB
GO 

CREATE DATABASE MY_DB
GO