>>CS means case sensitive. Unless you have a good reason for that, I would recomend to reinstall SQL Server as case insensitive.
>
>BTW, do you know what is the default? I have been told that the person did a standard installation.

The default is Latin1_General_CI_AS