CommitTransaction Element (XMLA)


Applies To: SQL Server 2016 Preview

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

   <CommitTransaction />  

Data type and lengthNone
Default valueNone
Cardinality0-n: Optional element that can occur more than once.
Parent elementsCommand
Child elementsNone

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.

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

Community Additions