Is there any way to show CAPS lock status in SMSS like we have in MS Word?

Question

Is there any way to show CAPS lock status in SMSS like we have in MS Word?

amar_sharma

SSC Journeyman

Points: 80
More actions
May 1, 2016 at 7:23 am

#326060

Hi,
I am trying to figure out if there is any way to show CAPS lock status in SSMS like we have in MS Word?
For instance, we can right click on the Status Bar in Word or Excel and enable or disable the status of CAPS lock to show there. (Please see the attachment).
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 1

Not that I'm aware of.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Luis Cazares SSC Guru Points: 183698 More actions · Answer 2

CAPS lock is affected system wide, so the indicator in the keyboard should be enough.

If there's no indicator in the keyboard, there's usually an icon next to the clock.

Why would you want to use the mouse when you're going to use the keyboard anyway?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 3

It's funny... SSMS shows "INS" and "OVR". It wouldn't have killed them to add "CAP" to the status bar.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

amar_sharma SSC Journeyman Points: 80 More actions · Answer 4

@Brandie Tarvin, Thanks for replying.

@luis Cazares, I felt the need of CAPS Lock status, because, I don't have to look at keyboard and am able to write code with best practices, like "SELECT TOP 10 *, UPPER(firstname) FROM dbo.mytable;". So, if the status is there on the screen I don't have to switch my eyes to keyboard every time I have want to confirm the status. Nothing very special about it, but, I thought there might have been some way that I may not be aware of, like, they have for MS Word and MS Excel. Switching On/Off I would prefer with keyboard itself. Just needed the status in the Status Bar. Thanks for your time anyways...! appreciate it.

@jeff Moden, You are right, Microsoft should have considered it... Thanks to you too for your time and reply..!!