MS SQL - Kill DB connections

declare @execSql varchar(1000), @databaseName varchar(100)

-- Set the database name for which to kill the connections

set @databaseName = 'WBE_SAAS'

set @execSql = ''

select @execSql = @execSql + 'kill ' + convert(char(10), spid) + ' '

from master.dbo.sysprocesses

where db_name(dbid) = @databaseName

and

DBID <> 0

and

spid <> @@spid

exec(@execSql)