rollbacktransaction-element-xmla.md

title	RollbackTransaction Element (XMLA) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	RollbackTransaction Element
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	http://schemas.microsoft.com/analysisservices/2003/engine#RollbackTransaction microsoft.xml.analysis.rollbacktransaction urn:schemas-microsoft-com:xml-analysis#RollbackTransaction
helpviewer_keywords	RollbackTransaction command
ms.assetid	40e7dc00-656f-412f-97f0-d05bf7caa196
caps.latest.revision	13
author	jeannt
ms.author	jeannt
manager	erikre

RollbackTransaction Element (XMLA)

Rolls back a transaction on the current session with an instance of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion].

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 [!INCLUDEssASnoversion] instance decrements the reference count of transactions for the current session to zero, rolling back all active transactions.

See Also

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