The sort order that you defined during the installation of Microsoft SQL Server determines case-sensitivity.