Note that you can also change your database, or table collation as well (if you don't want your entire server running that way)

So if you're using SQL_Latin1_General_CP1_CI_AS, try SQL_Latin1_General_CP1_CS_AS