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).
