| Author | Topic | 
                            
                                    | malachi151Posting Yak  Master
 
 
                                        152 Posts | 
                                            
                                            |  Posted - 2012-03-14 : 11:31:24 
 |  
                                            | I'm running the Eval version of 2012, and in SSMS it seems that there are some issues with the shortcut keys, anyone else noticing this?First of all, they no longer have a SQL 2000 layout available, not that you can't customize it, but...Also, I thought that CTRL+E was a standard shortcut for Executing a query? Doesn't work now.Also, in 2008 SSMS if I have something selected in the Object Explorer and I hit F5 it refreshes the node, however now under Options is says that F5 will refresh, but it doesn't work, it runs the debugger instead, even when you aren't in the query window.Also, I can't hit CRTL+SHIFT+C or CTRL+SHIFT+R to commend and un-comment, nor do I seem to be able to customize any combination of keys to do this....These are just some examples.Anyone else experiencing stuff like this or is it just me?--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |  | 
       
                            
                       
                          
                            
                                    | tkizerAlmighty SQL Goddess
 
 
                                    38200 Posts |  | 
                            
                       
                          
                            
                                    | malachi151Posting Yak  Master
 
 
                                    152 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 12:52:49 
 |  
                                          | quote:According to the documentation CTRL+E for execute was part of the standard:http://msdn.microsoft.com/en-us/library/ms174205.aspxI dunno, I've always used the SQL 2000 setup. CTRL+E is a lot more convenient than F5. You have to pickup your hand to hit F5, and you hit CTRL+E with your hand in the home position on the keyboard....Also, CTRL+SHIFT+C/R is much easier for multiple levels of commenting than having to hit two separate sequences...But at any rate, so its just the way it is then... Alright, thanks.Oh, but one question, so how do you refresh a node in the object explorer now then? Is the only way to use the mouse, there is no longer any keyboard shortcut? (I can always set one up, but still...)--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftwareOriginally posted by tkizer
 CTRL+e!  Wow, now that takes me back at least a decade. Please use F5. I'm surprised that MS even supported CTRL+e this long.  F5 was added so many years ago.For comments, use CTRL+k+c.  For uncomments, use CTRL+k+u.  This has been true since 2005 as they switched to the Visual Studio-way.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
 
 |  
                                          |  |  | 
                            
                       
                          
                            
                                    | robvolkMost Valuable Yak
 
 
                                    15732 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 13:55:07 
 |  
                                          | F5 refreshes nodes of the treeview.  If you check the menus in SSMS you'll see key bindings for most of the commands.  They change dynamically depending on which panel/window/tab is active. |  
                                          |  |  | 
                            
                       
                          
                            
                                    | malachi151Posting Yak  Master
 
 
                                    152 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 14:29:16 
 |  
                                          | quote:That's what I thought, but right now when I hit F5 in the tree view it runs the debugger...Thanks--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftwareOriginally posted by robvolk
 F5 refreshes nodes of the treeview.  If you check the menus in SSMS you'll see key bindings for most of the commands.  They change dynamically depending on which panel/window/tab is active.
 
 |  
                                          |  |  | 
                            
                       
                          
                            
                                    | robvolkMost Valuable Yak
 
 
                                    15732 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 14:35:24 
 |  
                                          | It works in SQL 2012 RTM, if you have MSDN or Technet you should download it. |  
                                          |  |  | 
                            
                       
                          
                            
                                    | malachi151Posting Yak  Master
 
 
                                    152 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 17:25:31 
 |  
                                          | I've also noticed that I can't change the font color for plain text from teal to black, and the teal is killing my eyes. In the past 2 days since using the new SSMS I'm getting eye strain and head aces and never had that before. I switched back to SSMS 2008 and I feel better. In SSMS 2008 the color of tings like column and table names is determined by the Plain Text setting, but changing that value in SSMS 2012 has no effect...--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftware |  
                                          |  |  | 
                            
                       
                          
                            
                                    | robvolkMost Valuable Yak
 
 
                                    15732 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 17:57:07 
 |  
                                          | Which "plain text" are you referring to?  I changed mine without any issues (Tools|Options|Environment|Fonts and Colors). |  
                                          |  |  | 
                            
                       
                          
                            
                                    | malachi151Posting Yak  Master
 
 
                                    152 Posts | 
                                        
                                          |  Posted - 2012-03-14 : 18:18:57 
 |  
                                          | quote:Yeah, that's where i'm setting it. Its not having any effect. I've even restarted.Ahh well...--------------------------------------------------My blog: http://practicaltsql.net/Twitter: @RGPSoftwareOriginally posted by robvolk
 Which "plain text" are you referring to?  I changed mine without any issues (Tools|Options|Environment|Fonts and Colors).
 
 |  
                                          |  |  | 
                            
                       
                          
                            
                                    | tkizerAlmighty SQL Goddess
 
 
                                    38200 Posts |  | 
                            
                       
                          
                            
                                    | X002548Not Just a Number
 
 
                                    15586 Posts |  | 
                            
                            
                                |  |