CREATE proc uspKillDBConnections -- uspKillDBConnections 'pubs'
(
	@dbName		sysname
)
as
declare	@sqlStatement	varchar(255)
declare @spid		int
declare curUsers cursor for
	select	spid
	from 	sysprocesses
	where	dbid = db_id(@dbName)
while (select count(*) from sysprocesses where dbid = db_id(@dbName)) > 0
begin
	waitfor delay '00:00:03'
	open curUsers
	
	fetch next from curUsers into @spid
	
	while (@@fetch_status <> -1)
	begin
		select 	@sqlStatement = 'kill ' + cast(@spid as varchar)
		exec(@sqlStatement)
		
		fetch next from curUsers into @spid
	end
	
	close	curUsers
end
deallocate curUsers

GO