PDA

View Full Version : Updating Stored Procedure Through SQL Management Console


SteveP55419
08-01-2008, 05:43 AM
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

SteveP55419
08-02-2008, 03:44 AM
I figured it out. You save your changes by clicking the 'Execute' button.

wisemx
08-02-2008, 03:45 AM
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. http://community.discountasp.net/emoticons/wink.gif
Salute,
Mark