Chapter 3: New Case-Insensitive Sort Order For Chinese and Japanese Character Sets
sp_configure
To switch to a case-insensitive sort order, enter:
sp_configure 'default sortorder id', 52