save the SP | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

save the SP

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?
You need to alter the procedure using ALTER PROCEDURE…….. Madhivanan Failing to plan is Planning to fail
… and you have to press F5 to execute the script, which will effectively store the procedure (now you see where it gets its name).
That Was IT! Thanks a lot!
]]>