Add "alter object" next to "select object in object explorer"
For example on a stored procedure, it's time consuming to first click select object in explorer, then right click on the object, then click modify. For a table, same, but clicking design. Plus sometimes if the database sproc isn't expanded yet its slow as the left side menu bounces around expanding first...
Double clicking a result should open the item for me to modify. Most of the time I'm looking for a stored procedure, often I've got the exact name or I know roughly the name and I'm using SQL Search to quickly get to it. When I select the item in the results I'd like to be able to right click and go straight to modify it.
At the moment I can double click and jump to that item in the Object Explorer, then right click and go to modify (or use the keyboard to right click and then press Y to modify). This is poor, I want to be quicker than that. At the moment the only item on the context menu is copy... so either don't bother with the context menu or extend it
I would like to alter object directly from SQL Search result without having to double-click them and then right clicking and altering them via object explorer.
Ludvig Derning commented
Excellent: But use "drop and create to" instaed so not to destroy the debugging with wrong editions in cache.
definitely needed. Note there are at least 4 different suggestions now that cover this idea and the related context menu idea. Can the moderator please combine these so the vote count is reflected. thanks
I think the suggestion to "Add option to the context menu for a result to open the item for modification" would be better.
Under the search results and above the script of he selected result is a link "Select object in Object Explorer" - you could add another link for "ALTER script in query editor" and/or "DROP/CREATE script in query editor".
Please add this to the Right Click context menu for Search Results too. So I can search for something, right click it, select "Script as Alter" and get a new query window the the alter script.
Also name the sql file to the name of the object