Displays the Microsoft® SQL Server™ sort order and character set.
sp_helpsort
0 (success) or 1 (failure)
None
The default is case-insensitive dictionary sort order.
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 server running SQL Server.
Execute permissions default to the public role.
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