Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 Just me or are the shortcut keys not working?

Author  Topic 

malachi151
Posting 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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-14 : 12:35:23
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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

malachi151
Posting Yak Master

152 Posts

Posted - 2012-03-14 : 12:52:49
quote:
Originally 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog



According to the documentation CTRL+E for execute was part of the standard:

http://msdn.microsoft.com/en-us/library/ms174205.aspx

I 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: @RGPSoftware
Go to Top of Page

robvolk
Most 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.
Go to Top of Page

malachi151
Posting Yak Master

152 Posts

Posted - 2012-03-14 : 14:29:16
quote:
Originally 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.



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: @RGPSoftware
Go to Top of Page

robvolk
Most 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.
Go to Top of Page

malachi151
Posting 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
Go to Top of Page

robvolk
Most 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).
Go to Top of Page

malachi151
Posting Yak Master

152 Posts

Posted - 2012-03-14 : 18:18:57
quote:
Originally posted by robvolk

Which "plain text" are you referring to? I changed mine without any issues (Tools|Options|Environment|Fonts and Colors).



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: @RGPSoftware
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-14 : 18:42:26
Sounds like there's bugs in the eval version that aren't in the regular version Rob has. malachi, probably should wait until April 1st when non-eval is available outside of msdn/technet.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-15 : 12:51:48
I want my [CTRL]+E

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page
   

- Advertisement -