/*********************************************************************
 * KillCycle: Continuously kill processes for a database
 *********************************************************************/
declare
	@xsql	varchar(256),

	@dba	varchar(25),
	@dbid	int

-- Specify account to exclude from kill
set @dba = 'username';

-- Specify Database ID to kill processes for
set @dbid = 23;

while(1=1)
begin
	declare kill_cur cursor for
		select 
			'kill ' + convert(varchar(05), spid) 
		from 
			master..sysprocesses 
		where 
			dbid = @dbid
			and sid != (
				select 
					sid 
				from 
					master..sysxlogins 
				where 
					name = @dba
			)
	for read only

	open kill_cur

	fetch next from kill_cur into @xsql

	exec(@xsql)

	while(@@fetch_status = 0)
	begin
		fetch next from kill_cur into @xsql
		exec(@xsql)
	end

	close kill_cur
	deallocate kill_cur
end