RollbackTransaction Element (XMLA)

Rolls back a transaction on the current session with an instance of Microsoft SQL Server 2005 Analysis Services (SSAS).

Syntax

<Command>
   <RollbackTransaction />
</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 RollbackTransaction command rolls back all active transactions, 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 to zero, rolling back all active transactions.

See Also

Reference

BeginTransaction Element (XMLA)
Cancel Element (XMLA)
CommitTransaction Element (XMLA)

Concepts

Commands (XMLA)

Help and Information

Getting SQL Server 2005 Assistance