SortOrder Property (SQL-DMO)

The SortOrder property returns a string describing the character set used and ordering applied for a Microsoft® SQL Server™ installation.

Applies To

Registry Object

Syntax

object.SortOrder

Part	Description
object	Expression that evaluates to an object in the Applies To list

Remarks

Character set and ordering compatibility between SQL Server installations can positively affect operations affecting more than one server. For example, distributed query is optimized when two installations are character set and order compatible. Character set and order are established at installation.

Data Type

String

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetSortOrder(SQLDMO_LPBSTR pRetVal);

Note SQL-DMO strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference by using SysFreeString.