Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Make section lowercase keyboard shortcut is not working

Posted on 2010-09-21
7
Medium Priority
?
1,884 Views
Last Modified: 2012-05-10
Hi Expert,
In MS SQL 2008-->Management Studio-->Query Analyzer,  Ctrl+Shift+U makes the remarked text uppercase no problem.
But Ctrl+U or Ctrl+Shift+L not working.

When I click on the menu link under Edit-->Advanced-->Make Lowercase(Ctrl+Shift+U), it's working.
When I click on the mhe menu link under Edit-->Advanced-->Make Uppercase(Ctrl+U), it's working.
Keyboard Shortcut "Ctrl+U" sends the focus to the "Available Databases" combobox.
Keyboard Shortcut "Ctrl+Shift+L" deteles the whole sql row.

Please tell me how can I lower the remaked text by a shortcut keyboard command.
Thanks,



Please tell me the shortcut ke
0
Comment
Question by:kosturdur
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33724685
Select the required text in SSMS and then choose

Ctrl+Shift+U -> Uppercase
Ctrl+Shift+L -> Lowercase
0
 
LVL 2

Accepted Solution

by:
mgrabarz earned 2000 total points
ID: 33724971
Go to Tools->Options... then Environment->Keyboard and press "Reset to Defaults" button. This operation should assign Ctrl+Shift+L back to Lowercase command.

0
 
LVL 5

Author Comment

by:kosturdur
ID: 33725761
Hi rrjegan17, mgrabarz

Ctrl+Shift+U -> Uppercase
Ctrl+Shift+L -> Lowercase --> doesn't work. It deletes the whole row in the sql statement

Go to Tools->Options... then Environment->Keyboard and press "Reset to Defaults" button. This operation should assign Ctrl+Shift+L back to Lowercase command.
In this parameter tab when I press "Reset to Defaults" button nothing changes.
In this parameter tab when I choose "Keyboard Sheme" as SQL Server 2000 then Ctrl+Shift+L works but this time the other MS SQL 2008 shortcut keys changed to SQL Server 2000.

Is there another way?






0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 5

Author Comment

by:kosturdur
ID: 33725787
I increase the points
0
 
LVL 5

Author Comment

by:kosturdur
ID: 33725863
In my next try everything worked fine.
Thanks,
0
 
LVL 2

Expert Comment

by:mgrabarz
ID: 33725928
Just tested "reset" solution on 3 separate installations of SSMS.
Initially Ctrl+Shift+L shortcut deletes row,  when pressed Reset button, then OK  and tried it again on query window it worked.

According to MSDN (http://msdn.microsoft.com/en-us/library/ms174205.aspx) both schemes use the same shortcut for Lowercase command and I guess your "Standard" settings are altered.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33730954
>> Ctrl+Shift+U -> Uppercase
Ctrl+Shift+L -> Lowercase --> doesn't work.

Seems like you have changed the default settings in SSMS and hence Reset to Defaults would have worked..
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question