Developing Matt

My Technical Journal

I would rather be in-sensitive

leave a comment »

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!

Advertisements

Written by matt

June 25, 2009 at 8:49 am

Posted in Sql Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: