I was recently working with a SQL database from the Commerce Starter Kit and needed to make a change to one of the stored procedures. I opened up the database using SQL Server Management Studio Express, drilled down to the stored procedures, right mouse clicked on the one I needed to edit and then clicked “Modify”. The code then appears in the query writer on the right hand side. I made the modifications and then went to “Save” and it just wanted to save the SQL query.

After some searching on Google, thanks to Jim Little’s post I learned instead of clicking “Save” you need to click “Execute”. The query that is shown is actually a query for modifying the stored procedure so you need to execute that query to have it make the changes in the database. It took me a minute but once I understood that clicking “Execute” would execute the SQL statement and not execute the stored procedure it all made since.

You can now “Save” the SQL and execute it on your production database as well.