if exists (select * from sysobjects where id = object_id(N'[dbo].[killspid ]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
begin
drop proc killspid

end
go
create proc killspid (@dbname varchar(20))  
as  
begin  
declare @sql nvarchar(500)  
declare @spid int  
set @sql='declare getspid cursor for  
select spid from sysprocesses where dbid=db_id('''+@dbname+''')'  
exec (@sql)  
open getspid  
fetch next from getspid into @spid  
while @@fetch_status < >-1  
begin  
exec('kill '+@spid)  
fetch next from getspid into @spid  
end  
close getspid  
deallocate getspid  
end  
go