SQL Server Performance

save the SP

Discussion in 'Getting Started' started by simosql, Jun 21, 2007.

  1. simosql New Member

    Hello world!
    I´m trying to make some modification on a Stored Procedure

    (SQL Query analizer {server} BAse Stored Procedures (folder)dbo.{store procedure})

    menu edit opens a Untiled text to edit (the SP´s content)

    I do the changes, and then menu Save, but that saves just the text! (the query in fact) in a file *.sql

    How do I change the dbo?
    What I´m doing Wrong?
  2. Madhivanan Moderator

    You need to alter the procedure using ALTER PROCEDURE........

    Madhivanan

    Failing to plan is Planning to fail
  3. Adriaan New Member

    ... and you have to press F5 to execute the script, which will effectively store the procedure (now you see where it gets its name).
  4. simosql New Member

    That Was IT! Thanks a lot!

Share This Page