用kill为何报错了?
use   master
go
declare   hyc   cursor   for
select   spid   from   sysprocesses   where   dbid=db_id( 'db_test ')
declare   @sd   int
open   hyc
while   @@fetch_status=0
begin
fetch   next   from   hyc   into   @sd
kill   @sd   --这里报错
end
close   hyc
deallocate   hyc

------解决方案--------------------

use master
go
declare hyc cursor for
select spid from sysprocesses where dbid=db_id( 'db_test ')
declare @sd int
open hyc
fetch next from hyc into @sd
while @@fetch_status=0
begin
exec( 'kill '+@sd) --这里报错
fetch next from hyc into @sd
end
close hyc
deallocate hyc