Settings and activity
3 results found
-
6 votes
Stuart Davis
supported this idea
·
-
14 votes
An error occurred while saving the comment An error occurred while saving the comment Stuart Davis
commented
Hey David, thanks for pointing that out. I did not know about the F12 option!
I would still find it extremely beneficial to have the scripts generated as ALTER by default and also to have the context menu offer an ALTER script to the clipboard too; or perhaps in the pop open script dialog window there could be buttons to copy the script to the clipboard both as either a create or an alter.
I am often in the scenario of building roll-out scripts or doing search-replace type operations on numerous scripted objects together and for this, scripting each object to a new window is not beneficial as I still need to copy to the clipboard and paste the scripts into one window where I am building my roll-out script or collating multiple objects to then do a global search/replace on etc
Thanks, Stuart.
Stuart Davis
shared this idea
·
-
212 votesStuart Davis
supported this idea
·
Yes this is great and I do use object explorer a lot, it retains some of the lost functionality you had by default in the previous Enterprise Manager, eg if I want to rename several objects, I can just get on and use the keyboard to jump alphabetically around the list directly with a single key press and use F2 to rename without having to keep going back to the mouse, selecting each object and then right-clicking to choose rename, back to the keyboard, getting RSI etc ;-)
Doing a bulk operation like a find/replace on several objects is fine if you know in advance which objects you need to select, but the vast majority of the time I don't have a pre-determined list of objects to work with, but instead will be building my script by working through existing procs, which is where the ability to pop open a referenced object's definition on the fly is such a useful feature. Being able to make use of this on the clipboard immediately as an alter script would still be a massive benefit, particularly as most of my work is with two SSMS apps on either monitor, working in one and pasting to the other.
In fact if there was be an option to *append* a script to the clipboard instead of just replacing the content of the clipboard then wow, I could save months, Lol.