In this article

In this article

sp_helpsort (Transact-SQL)

Syntax

sp_helpsort

Return Code Values

0 (success) or 1 (failure)

Result Sets

Returns server default collation.

Remarks

If an instance of SQL Server 2008 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').

Permissions

Requires membership in the public role.

Examples

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.