Use the default sortorder id option to show the ID of the default sort order currently installed on Microsoft® SQL Server™.
Note Use SQL Server Setup to change sort orders. Do not use SQL Server Enterprise Manager or the sp_configure system stored procedure.
default sortorder id is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change default sortorder id only when show advanced options is set to 1. This setting takes effect after stopping and restarting the server.
To display the default sortorder id option
Character Set | Sort Order |
RECONFIGURE | sp_configure |
Setting Configuration Options |