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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 364059 Comments
Status Closed Workarounds
Type Suggestion Repros 0
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 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