How to show CAPS lock status in Management Studio status bar?

  • Hi,

    How to show CAPS lock status in Management Studio status bar to know if CAPS Lock is on or off.

    Thanks.

  • SQL server determines case sensitivity by COLLATION.

    COLLATION can be set at various levels.

    Server-level

    Database-level

    Column-level

    Expression-level

    Here is the MSDN reference--https://msdn.microsoft.com/en-us/library/ms143726.aspx

    Check Server Collation--

    SELECT SERVERPROPERTY('COLLATION')

    Check Database Collation--

    SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;

    Check Column Collation

    select table_name, column_name, collation_name

    from information_schema.columns

    where table_name = @table_name

  • amar_sharma (5/1/2016)


    Hi,

    How to show CAPS lock status in Management Studio status bar to know if CAPS Lock is on or off.

    Thanks.

    How many times are you going to ask the same question that you've already been given an answer to? 😉

    --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)

  • @jeff Moden, :blink: It was on the same day, as, didn't get any reply and views were increasing, so, being a newbee, I doubted myself, whether I have asked in the right Group or not and hence came this one, but, swear, there is no 3rd instance anywhere on the web.... :exclamation: ... But I am very appreciative of, that, you were able to hit it here too.... !!! Thanks again..!:satisfied:

    @abhiseck, thanks for explaining COLLATION ....

  • You could ask directly to Ken Van Hyning, who is the SQL Client Tools Engineering Manager at Microsoft.

    P.S. We're everywhere and we see it all. 😀

    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
  • amar_sharma (5/4/2016)


    @Jeff Moden, :blink: It was on the same day, as, didn't get any reply and views were increasing, so, being a newbee, I doubted myself, whether I have asked in the right Group or not and hence came this one, but, swear, there is no 3rd instance anywhere on the web.... :exclamation: ... But I am very appreciative of, that, you were able to hit it here too.... !!! Thanks again..!:satisfied:

    @abhiseck, thanks for explaining COLLATION ....

    Ah... got it. Thanks, Amar.

    --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)

  • my keyboard has a light to signify caps lock on or off, isn't that significantly easier than asking for one specific application to show it's status? just glance at the keyboard?

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • SQL Prompt will automatically adjust the case, so I don't care whether caps lock is on. Also, it becomes quickly obvious as you're typing that the wrong case is being used. (As a touch typist that uses a soft keyboard mapping that doesn't match the physical labels (Dvorak), I almost NEVER look at the keyboard.)

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • You are welcome, Jeff. It was a pleasure to see your replies on the post..!!

    Thanks.

  • @luis Cazares, I'll try that. Could you please help me with his genuine email?

    Thanks.

  • amar_sharma (5/6/2016)


    @Luis Cazares, I'll try that. Could you please help me with his genuine email?

    Thanks.

    Why do you think I have it?

    And if I did, I wouldn't share it to anyone, unless it's already publicly available.

    Another option is to file a Connect item and get enough votes on it.

    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
  • amar_sharma (5/6/2016)


    You are welcome, Jeff. It was a pleasure to see your replies on the post..!!

    Thanks.

    Thanks for the feedback, Amar. Just to be sure, most of the heavy hitters at least look at "Posts Added Today" under "Recent Posts" in the menu above. That covers ALL the forums available on this site. With the number of members on this site, you'll frequently get a lot of "views" with no answer before someone actually answers and is sometimes because people are trying to find the answer to a similar problem and have no solution of their own to offer. Unlike some of the "stab'n'grab' forums out there, it's usually well worth the wait, especially on code or complex problems. People are actually encouraged to offer different opinions and levels of detail even if an answer has already been posted, which I think is really cool because the discussions are where the real learning is at.

    --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)

Viewing 12 posts - 1 through 11 (of 11 total)

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