Collation Element (ASSL)

Determines the collation used by the parent element.

Syntax

<Database> <!-- or one of the elements listed below in the Element Relationships table -->
   ...
   <Collation>...</Collation>
   ...
</Database>

Element Characteristics

Characteristic	Description
Data type and length	String
Default value	None
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent elements	Cube, Database, DataItem, Dimension, MiningModel, MiningStructure
Child elements	None

Remarks

The Collation string consists of the locale identifier (LCID) and the comparison flag, separated by an underscore character. For example, Latin1_General_CI_AS is an acceptable string.

The elements that correspond to the parents of Collation in the Analysis Management Objects (AMO) object model are Cube, Database, DataItem, Dimension, MiningModel, and MiningStructure.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance