SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

by Pelin   Last Updated July 16, 2018 15:00 PM

I am installing an OLT Software that requires Windows SQL Server 2008.

I am getting this error below;

The database sort order must be "binary sort". Please run the Transact-SQL command sp_helpsort to check the current database sort order.

Output of sp_helpsort is;

Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive,
width-insensitive for Unicode Data, SQL Server Sort Order 52 on Page 1252 for 
non-Unicode Data

How could I change sort order to "binary sort" in order to proceed installation?

Thanks!



Related Questions



How can I get SeSecurityPrivilege enabled?

Updated April 08, 2017 09:00 AM


Migrate windows server 2008 r2 and 2012 to 2016

Updated December 31, 2017 17:00 PM

HP ProLiant DL380 G7 HPTEAM Error

Updated April 09, 2015 19:00 PM