Make MSSQL server case sensitive

One should use COLLATE keyword when creating table. Or later by ALTERing it.

CREATE TABLE [mytable] (
A CHAR(10) COLLATE Latin1_General_CS_AS)

In this case SQL server compares words as is taking into account the case of letters.