If u have to just modify the stored proc then no need of first drop the proc and again create. just open the existing proc and replace the keyword create by alter and excute it.then i hope u will get same result as u expect.