Beta test 7.0

During testing I came up with an new option for opening a stored procedure.
From the Explorer menu you can select a stored procedure and from the context menu choose Edit Procedure.
But when you are inside a stored procedure where another procedure is executed it would be realy nice if there was an option the select this stored procedure name and from the context menu select 'Edit procedure'. Now I have to follow some extra steps to open it in een new window.
Copy the name, paste it in the Database Explorer and select 'Edit procedure'

Try Ctrl+click, then Copy icon in the DDL view window to copy code to the clipboard or to the editor window

Last edited by SysOp on Wed Jul 02, 2014 7:32 pm; edited 1 time in total

You could Ctrl+Click the stored procedure as well. That would retrieve its DDL in an SA tab. You can do whatever you want with it using the icon in top-right corner (copy all, move to editor, compare to editor, etc.)

EDIT: ehh, too slow, I was, yes :)

OK, that works, but I miss a few things compared to open from the Explorer with 'Edit procedure'

With Edit Proccedure you get:
USE [TestRestore]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[IPS_prc_Post_XML2DB]

And with Ctrl+click you get
CREATE PROCEDURE [dbo].[IP_gen_Log]

And it is the lines before ALTER PROCEDURE that I like this way to open the stored proceure text.
And I take the extra time it takes to open a new Window for granted.

I have submitted an enhancement request to add Edit... to the right-click menu

Adding the missing details mentioned by sqltogo to the results retrieved by ctrl+click and another icon to the result panel that would open the contents in a new window would be a nice addition as well. Or and edit link to the bubble opened when hovering over the object. The menu is cluttered enough already, I think.

Tested in latent build, Works perfect, For me one of the best new features