Kill all processes in specified database(s)

killprocesses.sql

declare @spid int, @cnt int, @sql varchar(255)

select @spid = min(spid), @cnt = COUNT(*)
  from sysprocesses p
 inner join sysdatabases d on p.[dbid] = d.[dbid]
 where d.name like '%Internal%'

print 'Killing ' + CAST(@cnt as varchar) + ' processes.'

while @spid is not null
begin
    set @sql = 'KILL ' + CAST(@spid as varchar)
    print @sql
    exec (@sql)

    select @spid = min(spid), @cnt = COUNT(*)
      from sysprocesses p
     inner join sysdatabases d on p.[dbid] = d.[dbid]
     where d.name like '%Internal%'
end