>>If you use intellisense, it uses correct casing when automatically expanding the table names / field names. Of course, you can always type yourself to overwrite this.
>
>But, I have same versions on various servers and this one acts differently. So, based on what you wrote, I assume there is a setting somewhere. Is that correct? And, yes, if I type over, I can control it.
What exactly is different and what is the exact behavior you're experiencing?
When I type something like
select
from myTable T
and then type T. I can see the columns in that table and they will use correct casing.
If it's not broken, fix it until it is.
My Blog