sp_helpsort
SQL Server 2000
Displays the Microsoft® SQL Server™ sort order and character set.
Syntax
sp_helpsort
Return Code Values
0 (success) or 1 (failure)
Result Sets
Returns server default collation.
Remarks
If SQL Server 2000 is installed with a collation specified to be compatible with an earlier installation of SQL Server, sp_helpsort will return blank results. In this case, the collation can be determined by querying the SERVERPROPERTY object and specifying 'Collation' as the propertyname. For example,
SELECT SERVERPROPERTY ('Collation')
Permissions
Execute permissions default to the public role.Examples
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
This 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.
