This topic has not yet been rated - Rate this topic

CommitTransaction Element (XMLA)

SQL Server 2012

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


<Command>
   <CommitTransaction />
</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	None

Remarks

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.

Reference

BeginTransaction Element (XMLA)

Cancel Element (XMLA)

RollbackTransaction Element (XMLA)

Concepts

Commands (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD