use [master] 
go 
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) 
drop procedure [dbo].[p_killspid] 
GO 
create proc p_killspid 
@dbname sysname 
as 
begin  
    declare @s nvarchar(1000) 
    declare tb cursor local for 
    select s='kill '+cast(spid as varchar) 
    from master..sysprocesses  
    where dbid=db_id(@dbname) 
    open tb  
    fetch next from tb into @s 
    while @@fetch_status=0 
    begin 
    exec(@s) 
    fetch next from tb into @s 
    end 
    close tb 
    deallocate tb 
end
go 
exec p_killspid  'Chaoshi' 

String str="use master " + 
   " go "+ 
           " if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_killspid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) " + 
  "drop procedure [dbo].[p_killspid] " + 
  " go "+ 
  " create proc p_killspid " + 
  " @dbname sysname " + 
  " as " + 
  " declare @s nvarchar(1000) " + 
  " declare tb cursor local for " + 
  " select s='kill '+cast(spid as varchar) " + 
  " from master..sysprocesses " + 
  " where dbid=db_id(@dbname) " + 
  " open tb " + 
  " fetch next from tb into @s " + 
  " while @@fetch_status=0 " + 
  " begin " + 
  " exec(@s) " + 
  " fetch next from tb into @s " + 
  " end " + 
  " close tb " + 
  " deallocate tb "+ 
  " go ";