sp_configure

To switch to a case-insensitive sort order, enter:

sp_configure 'default sortorder id', 52