Export (0) Print
Expand All
Expand Minimize

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.

See Also

COLLATE

Collations

fn_helpcollations

SERVERPROPERTY

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft