Updating Stored Procedure Through SQL Management Console

Hi Gang,

I added a few columns to a table and was able to make the changes in SQL 2005 Mangement Studio OK. Then I tried to change the stored procedures and sort of fumbled around. I did this last night. Turns out this morningthat my changes was saved on one of them but not the rest. Could someone tell me how to do this please?

Thanks.

Steve

 

I figured it out. You save your changes by clicking the 'Execute' button.

 

Good job.
Sorry I messed this one, I usually try to help with this sort of problem right away but this week has been nuts.
Salute,
Mark