Locate Object in Object Explorer focused in SQL Editor

Locate object in Object Explorer located at cursor position directly from SQL Editor.
Keyboard Shortcut: [Ctrl-F2]

Locate objects in SSMS object explorer with SSMSBoost add-in

An often need is to know more information about object under the cursor: its columns, parameters (for function or procedure), other properties. If a database has hundreds of objects, locating an object in the Object Explorer can take some time. SSMSBoost allows to locate object in seconds! Just place the cursor on the identifier and
  • press Keyboard Shortcut [Ctrl-F2]
  • right-click the identifier and select "Locate object" from the context menu

SSMSBoost performs search for valid identifiers at cursor location and allows you to select, which one you want to locate. If you select part of the identifier - SSMSBoost will perform no search and will use selected text as object identifier.
Object fill be focused in Object Explorer and it's node will be expanded. So that you can easily access it's properties and, for example, drag-n-drop parameters of stored procedure into SQL Editor window. If you want to change the default Keyboard Shortcut of "Locate object" feature you can do that using other feature of SSMSBoost - Shortcuts editor (needed only in SSMS 2008, as far as SSMS 2012 and later versions finally have built-in shortcuts editor)