Home Dashboard Directory Help

SSMS : CTRL+SHIFT+R needs to be more discoverable and/or documented by AaronBertrand


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Suggestion
ID: 364059
Opened: 8/27/2008 3:43:59 PM
Access Restriction: Public


A lot of people have complained that if they have a query window open, and in that query window add a column to a table or create a new table, subsequent queries using IntelliSense do not recognize the change. Of course this is because the local metadata cache is stale, and needs to be refreshed using Ctrl+Shift+R or Edit > IntelliSense > Refresh Local Cache.

If you look at items like #363883, #336481, #360585, in each case Eric Kang has posted a comment, basically having to tell people what the keyboard combination is, because they clearly haven't found the menu option. I think this is for several reasons:

(a) "Refresh Local Cache" is not documented in Books Online. At all. I would expect this SSMS menu option to be documented somewhere, especially at the keyboard shortcut page:
But no, it is not there. I did find CTRL+SHIFT+R under 2000 keyboard scheme, but this is for uncommenting and has nothing to do with IntelliSense obviously.

(b) As I complained in #342260, keyboard shortcuts like CTRL+SHIFT+R are not listed under Tools/Options/Environment/Keyboard, where other shortcuts like F1 are defined.

(c) The menu option is in a really weird place; in fact, probably the LAST place I would have looked.
Sign in to post a comment.
Posted by Microsoft on 6/1/2010 at 10:56 PM
Hi Aaron

Thanks for taking the time to submit your issue!
We have asked the documentation team to update the following link
http://msdn.microsoft.com/en-us/library/ms174205.aspx with keyboard shortcut for Refresh Local Cache and document the behavior in detail as suggested by you.

Posted by David Sarembock on 10/6/2008 at 8:39 AM
I found the Intellisense refresh cache under edit-> Intellisense just for future refrence but as i'm a developer using Visual Studio i'm used to not having to the refresh cache all the time as that would get very annoying in a fast paced workplace
P.S. put support back in from previous versions of Intellisense would make it easy to make transition from 05 to 08 much easyer
Posted by Microsoft on 9/5/2008 at 10:22 AM
Hello Aaron Bertrand,

Thank you for your input via the connect website. Based on earlier feedbacks, I expect the product team to look at the problem and address the broader problem of not having to refresh the cache frequently for a future release. I agree the current hotkey combination may not be immediately known to users. I will check to see if Books On Line or MSDN can be updated to make this information more accessible.


Program Manager | SQL Server
Sign in to post a workaround.