Kill all users in specified database(s)

killdbusers.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