SQL Server Performance

Modifying a Stored Procedure

Discussion in 'SQL Server 2005 General Developer Questions' started by vcklo, Jul 2, 2009.

  1. vcklo New Member

    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
    vcklo, Jul 2, 2009
    #2

  2. MohammedU New Member

    May be you are clicking the save button instead of execute...
    Try just pressing F5 or CTRL E after modifications....
    MohammedU, Jul 2, 2009
    #3

  3. vcklo New Member

    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.
    vcklo, Jul 2, 2009
    #4

  4. FrankKalis Moderator

    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. [:)]
    FrankKalis, Jul 2, 2009
    #5

  5. AMOURGH New Member

    Hi Frankkalis, Can you tell us where(tables) SQL Server saves all the code in system tables?ThanksRachid
    AMOURGH, Jul 4, 2009
    #6

Share This Page