patternsqlMinor
In SSMS, is "Navigate to" (Ctrl+,) of any use?
Viewed 0 times
navigatessmsanyctrluse
Problem
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
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.
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.
Solution
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.
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.
Context
StackExchange Database Administrators Q#137058, answer score: 4
Revisions (0)
No revisions yet.