CommitTransaction Element (XMLA)

APPLIES TO:yesSQL Server Analysis ServicesyesAzure Analysis Services

Commits a transaction on the current session with a Microsoft SQL Server Analysis Services instance.


   <CommitTransaction />  

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 None


The CommitTransaction command commits an active transaction, explicitly defined using the BeginTransaction element, on the current session. If an active transaction does not already exist, an error occurs. If an active transaction already exists, the Analysis Services instance decrements the reference count of transactions for the current session. If the reference count of explicitly defined active transactions reaches zero, the Analysis Services instance commits the transaction.

See Also

BeginTransaction Element (XMLA)
Cancel Element (XMLA)
RollbackTransaction Element (XMLA)
Commands (XMLA)