Opened up SQL 2008 Management Studio. Double-click on a job, up pops the Job Properties screen. So far, so good. Go to the step properties, up pops another window, all still good. Next, hit CRTL-A and get beeped. WTF? I have to right-click in order to do a select all? No keyboard shortcut? I see that CTRL-C and CTRL-V work, but not CTRL-A? It is as if someone at MSFT consciously decided to remove the ability to use your keyboard for this one function. I know it did not work in SQL 2005, I guess I figured someone else would have noticed and fixed it by now.
In the new SSMS many of the shortcuts have been radically changed or just flat out removed. Wait until you try to use CTRL-N for new query (my favorite)…gone baby gone!!
Yeah. And Ctl-N doesn’t work to open a new Query, and Ctl-Shift-M doesn’t work to fill in template values.
Which makes me feel that MS doesn’t love us DBA, at least not by our tool sets *shakes head*
Ctrl-N does work, after a quick “fix”.
In SSMS, go to Tools, Options. Choose Keyboard under the Environment node on the left, then change the “Keyboard scheme” to “SQL Server 2000”. Click OK, go back to Tools…Options and change the keyboard scheme back to “Standard”. Click OK once again.
Ctrl-N should now open a new query.
I thought I had reported this one, but couldn’t find it. I did find these other peculiarities that I reported earlier this year:
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=361772
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=361774