Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance
Displays the sort order and character set for the instance of SQL Server.
Return Code Values
0 (success) or 1 (failure)
Returns server default collation.
If an instance of SQL Server is installed with a collation specified to be compatible with an earlier installation of SQL Server, sp_helpsort returns blank results. When this behavior occurs, you can determine the collation by querying the SERVERPROPERTY object, such as:
SELECT SERVERPROPERTY ('Collation');.
Requires membership in the public role.
The following example displays the name of the default sort order of the server, its character set, and a table of its primary sort values.
Here is the result set.
Server default collation
Latin1-General, case-sensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 51 on Code Page 1252 for non-Unicode Data.