Skip to content

Latest commit

 

History

History
29 lines (24 loc) · 1.82 KB

File metadata and controls

29 lines (24 loc) · 1.82 KB
description Using Transactions
title Using Transactions | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology
ms.topic reference
helpviewer_keywords
SQL Server Management Objects, transactions
transactions [SMO]
SMO [SQL Server], transactions
ms.assetid 399aded8-bee3-4cfb-a671-1877c7d0de9f
author markingmyname
ms.author maghan
monikerRange =azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Using Transactions

[!INCLUDE SQL Server ASDB, ASDBMI, ASDW ]

In [!INCLUDEssNoVersion] Management Objects (SMO), transaction processing is achieved through the connection to the instance of [!INCLUDEssNoVersion] by using the xref:Microsoft.SqlServer.Management.Common.ServerConnection object. The xref:Microsoft.SqlServer.Management.Common.ServerConnection object is referenced by the xref:Microsoft.SqlServer.Replication.ReplicationObject.ConnectionContext%2A property of the xref:Microsoft.SqlServer.Management.Smo.Server object when the connection is established. Methods such as xref:Microsoft.SqlServer.Management.Common.DataTransferProgressEventType.StartTransaction, xref:Microsoft.SqlServer.Management.Common.ServerConnection.RollBackTransaction%2A, and xref:Microsoft.SqlServer.Management.Common.ServerConnection.CommitTransaction%2A belong to the xref:Microsoft.SqlServer.Management.Smo.Server.ConnectionContext%2A object property.

See Also

Creating SMO Programs