Comments that appear before ALTER statement should be preserved
Currently any comments that appear before the ALTER PROC statement are not scripted by SQL Prompt which results in those comments being silently deleted if the alter statement is executed.
If I hover the mouse over a stored procedure name and click on the procedure name that pops up in order to see the script window I can see these comments but if I type alter proc <procname> and press tab to produce an alter script these comments are missing.
There is a danger here of losing comments without the user being aware of it. I think SQL Prompt should have consistent behavior around scripting procedures regarding comments.
8
votes
Sterling Hickox
shared this idea
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/