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.
WORKAROUND:
Manually refresh the stored proc in database explorer before generating SQL.
Or use the other "Alter stored procedure" option (not directly in the editor), through the alter pop up window. This option is also in the right click menu for an object in the database explorer.
STATUS:
Waiting for a fix, to defect ID 'TSS-1168', to be released in a future version of Toad for SQL Server.
