4 results found

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

   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… more

   8 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Script object as alter  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

2. Surround templates added to snippet manager.

   So you could highlight a column and surround it with isnull() for example.
   Or surround a sql query and surround it with begin and end.

   11 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Script object as alter  ·  Delete…  ·  Admin →
   completed  ·  Aaron Law responded

   This is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

3. Script Object as ALTER feature should not use cached scripts

   Please see forum thread http://www.red-gate.com/MessageBoard/viewtopic.php?t=14749

   I ran into what I would consider a serious issue with the Script Object as ALTER feature. A few hours earlier I had changed a stored procedure script and executed the Alter script so the change was now "active".

   A few hours later, within the same SSMS application (but different query window) I used the right-click Script Object option as a shortcut so I didn't have to scroll through a very long list in Object Explorer... Unfortunately it scripted the OLD version of the procedure and not the one changed hours earlier.

   Now, I know this is because I didn't hit "Refresh Suggestions" (which I subsequently did and got the newer version), but my point is that this is exceptionally dangerous given an environment where changes are not always known by all individuals and where there is no DBA to manage all changes. I could have blown out hours of work or critical changes by executing the generated cache-scripted version and never known until all hell broke loose.

   Is there a very compelling reason to use caching instead of just scripting the most current version (which SSMS does in pretty much the same amount of time)? Is it more compeeling than potentially causing changes to be whacked?

   Please see forum thread http://www.red-gate.com/MessageBoard/viewtopic.php?t=14749

   I ran into what I would consider a serious issue with the Script Object as ALTER feature. A few hours earlier I had changed a stored procedure script and executed the Alter script so the change was now "active".

   A few hours later, within the same SSMS application (but different query window) I used the right-click Script Object option as a shortcut so I didn't have to scroll through a very long list in Object Explorer... Unfortunately it scripted the OLD version of the procedure and not the one changed hours earlier.

   Now, I know… more

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Script object as alter  ·  Delete…  ·  Admin →
   completed  ·  Paul Stephenson responded

   As of SQL Prompt 5.2.8, Script as ALTER will always fetch the script directly from the database.

4. Script object as alter not enabled for table-valued functions and views.
   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Script object as alter  ·  Delete…  ·  Admin →
   completed  ·  Thomas Walsh responded

   We’ve released support for this in SQL Prompt.

   You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

   Here’s the updated documentation for the Script as ALTER feature: https://documentation.red-gate.com/sp9/navigating-your-code/scripting-an-object-as-alter

   If there is something missing please let us know by opening a new suggestion.

   Kind regards,

   The Prompt Team