Add a script to Alter for Stored procedures found in SQL Search.
Add a option when you right click on the stored procedure you found to script it to an alter page similar to how you can do that if you find a nested SP in your code.
6
votes
Thomas Minniear
shared this idea
-
Günter Tschech commented
This should be available for all types of obects. For Views you currently have to perform 4 actions:
* click "Select in object explorer"
* open context menu
* select "script view as"
* select "create or alter to"
* select "new window"
- and the window does not have an appropriate name (as the F12 key from within a script window produces)