This topic has not yet been rated - Rate this topic

MergePartitions Element (XMLA)

SQL Server 2005

SQL Server 2008 R2
SQL Server 2008
SQL Server 2012

Merges the data of one or more source partitions into a target partition, and then deletes the source partitions.


<Command>
   <MergePartitions>
      <Sources>...</Sources>
      <Target>...</Target>
   </MergePartitions>
</Command>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-n: Optional element that can occur more than once.

Element Relationships

Relationship	Element
Parent elements	Command
Child elements	Sources, Target

Remarks

All object references in the Sources and Target elements must point to distinct partitions in the same measure group. Otherwise, an error occurs.

Concepts

Commands (XMLA)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD