SCRIPT: How to kill all connections from the database?

 USE master
GO
DECLARE @kill varchar(max) = '';
SELECT @kill = @kill + 'KILL ' + CONVERT(varchar(10), spid) + '; '
FROM master..sysprocesses
WHERE spid > 50 AND dbid = DB_ID('DATABASE_NAME') -- Change DB name
PRINT @kill
EXEC(@kill);