Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2009-09-23 : 11:37:23
|
| Throughout my SQL experience, I've always been able to use any case anywhere...In this recent database, I have to have to specify every object Like This or LIKE THIS or it's invalid.Is this rule in the database, on in my editor (SSMS)? Can I turn it off?Thanks |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-09-23 : 11:52:27
|
| The collation for the database (and therefore all system tables) is case sensitive. You can change it, but it will require dropping all indexes that are on char, varchar, or nvarchar fields, altering collation on all character fields in the database (excluding system tables), then rebuilding all those indexes you dropped. In other words, it will hurt. |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-09-23 : 12:00:03
|
| Good to know, but if, for so many years, I could call any object called hElLoMoNkEy hellomonkey or HELLOMONKEY, it means that it's possible to turn this off? I would leave this off for a database I created. |
|
|
|
|
|
|
Case-Sensitive Objects