I would rather be in-sensitive
Somehow I missed the fine print and downloaded the AdventureWorks Case Sensitive Database. Specifically, my collation is set to Latin1_General_CS_AS. The CS apparently stands for Case Sensitive. (To see the collation of your database right click, select properties, and go to the general tab…it’s at the bottom). Unfortunately, being AdventurWorks I have put up with it…until now. I’m tired of re-writing queries in the RiGht CaSe.
According to this article you can run this command (in single user mode)
ALTER DATABASE AdventureWorks COLLATE Latin1_General_CI_AS
But Sql server will bleed all over your screen with all kinds of dependency errors. Unfortunately collation can be set at the database, column, and table level. So to fix it you would have to change the collation at every level.
Or you can just download a new one from here. Make sure you pick one that has CI at the end of it.
FIXED!
