6

In standard Visual Studio 2012 or higher, IDE window called Navigate to... (Ctrl+,) offers all useful objects in scope of currently open project (see samples) getting increasingly filtered as I am typing so I can quickly navigate to what I need without expanding the tree with hundreds of items.

The same Navigate to... I can find in SQL Server Management Studio 2014 (perhaps since SSMS 2012?) but as I type, I can see only some backup files in SSMS %TEMP% directory. Is this everything what can be get from Navigate to...?

I would like to see it offering me names of tables, stored procedures and SQL functions etc. so I can jump to them in Object Explorer or view their definition. Any tricks to make Navigate to... more useful in the SSMS?

(Currently I have SSMS 2014 connecting to SQL Server 2008 R2.)

Note: I'm aware of various ways of navigating in SSMS, but now I would like to learn more about Navigate to... which is convenient typing-oriented search&go tool.

Improve this question

2 Answers 2

Reset to default
4

In SSMS 2016, Navigate To... is gone.

So the answer is that temporary presence of non-functioning Navigate To... feature in SSMS 2014 looks like forgotten artifact of adopting SSMS to Visual Studio platform. Perhaps we should seek nothing more serious behind it.

Comment: SSMS 2016 seems to be much more polished, it fixes many weird technical and design errors seen in SSMS 2014, including non-standard keyboard shortcuts. After leaving good SSMS 2008 and 3-of-5-stars experience with SSMS 2014 I recommend installing standalone SSMS 2016, which can get 4.5. They even can be installed and used side-by-side, if someone is hesitant to uninstall that 2014 thing on the first day. So far, I found only one issue with SSMS 2016.

Improve this answer
1

I am using SSMS 2018 and "Navigate to..." using Ctrl, is certainly there (still there/back). I don't know what it does, though.

Improve this answer
2
  • Welcome to Database Administrators. Please, wait until you have enough reputation to add comments, don't post them as answers to the question. Commented Jun 1, 2020 at 10:42
  • I'm using a recent/latest Win 10 version (v18.9.1), Ctrl+, does open a Go to All window, but it is pretty much useless. Best you can do is search your AppData folder from what I can see. Commented Jun 2, 2021 at 14:29

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.