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...
Bryan Brannon commented
Or use a hotkey - F12 to open the ALTER window up.
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