Solved

Make section lowercase keyboard shortcut is not working

Posted on 2010-09-21
7
1,802 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
  • 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 500 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now