Changes to a stored procedure is not properly refreshed.
1. Use the "Alter Stored Procedure in Editor" option, make a change, and execute the script to ALTER the stored proc.
2. With the same stored procedure, use the "Generate SQL" command to have the CREATE PROCEDURE script generated to the clipboard or the Editor
3. The generated script from step 2 does not contain the changes made in step 1. The changes are not refreshed automatically.
If the proc is refreshed manually from the database browser window the SQL is generated again, the changes from step 1 appear.
This is not an issue with other ways of altering the procedure. This is only an issue when using specifically the "Alter Stored Procedure in Editor" option.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center