declare @tname varchar(max)
set @tname=''
select @tname=@tname + Name + ',' from sysobjects where xtype='P'
select @tname='Drop Procedure ' + left(@tname,len(@tname)-1)
exec(@tname)