SortOrder Property

SQL-DMO

SQL-DMO

SortOrder Property

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

Applies To
Registry Object
Syntax

object.SortOrder

Parts

object

Expression that evaluates to an object in the Applies To list

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 using SysFreeString.

Remarks

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