Hi everyone,

 I have an existing database file that I am opening with MS SQL Server Management Studio Express with pre-existing Stored Procedures. I would like to make modifications to some of the procedures. I right-click on the procedure I would like to change and Click 'Modify...'

 However, after I finish making my changes and click 'Save', it prompts me to save the file as a new query file, which is not what I want to do. I want to update the Stored Procedure itself, not create a new query file. Can anyone clarify this situation for me?

 Thanks,

Victor

May be you are clicking the save button instead of execute...

Try just pressing F5 or CTRL E after modifications....

 Thanks. I was pressing the save button--I'm a novice and I had no idea that to save your changes you actually need to execute your statments for the changes to be saved.

SQL Server saves all code internally in some of its system tables. So if you want some code to be "persisted" to a database you need to inject it into the database by executing a script. Of course, no one keeps you from having a backup copy of the script somewhere on the file system.