Displays the SQL Server default sort order and character set.
sp_helpsort
Binary sort order is the default.
For the output of sp_helpsort to appear correctly on a client computer, the client must be running the same character set and code page as the SQL Server. For more information about sort orders, see Microsoft SQL Server Setup.
This example displays the name of the server's default sort order, its character set, and a table of its primary sort values.
sp_helpsort go Sort Order Description ---------------------------------------------------------------- Character Set = 2, cp850 Code Page 850 (Multilingual) character set. Sort Order = 40, bin_cp850 Binary Sort Order for the CodePage 850 Character Set Characters, in Order ----------------------------------------------------------------
Execute permission defaults to the public group.
master.dbo.syscharsets