Create case sensitive database with SQL Server

sql-server

Solution

You'll need to change your database collation to Latin1_General_CS_AS

Here's how to do that using T-Sql:

ALTER DATABASE yourdatabase
   COLLATE Latin1_General_CS_AS

Problem

By default database created with SQL server is case insensitive. If I add 2 keys with the same name but different case the second insertion is rejected. How can I change this behavior and make the database case sensitive?

Original source