Killing other processes connected to an MSSQL database.

mssq_killing_other_db_connections

declare @db_name varchar(100) = 'dbname';
declare @kill_commands varchar(max) = '';
 
select 
	@kill_commands=@kill_commands+'kill '+convert(varchar(5),spid)+';' 
from master..sysprocesses  
where 
	spid <> @@SPID -- avoid to kill the current process
	and dbid=db_id(@db_name)  
 
print 'Executing: ' + @kill_commands;
exec (@kill_commands);