SQLUSA
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server 2008 Training Scripts
SQL Server 2005 Training Scripts
SQL Server Training Scripts
SQL 2008 GRAND SLAM
How to execute a distributed TRANSACTION?

The following SQL Server T-SQL code sample A+ Markets gourmet food stores demonstrates the usage of distributed transactions to update the Customers table on the remote Linked Server and on the local server:

USE Northwind

BEGIN DISTRIBUTED TRAN

 

UPDATE LinkedServerName.Northwind.dbo.Customers

SET    CompanyName = 'A+ Markets'

WHERE  CustomerID = 'ABCD'

 

UPDATE Customers

SET    CompanyName = 'A+ Markets'

WHERE  CustomerID = 'ABCD'

 

COMMIT TRAN

After execution the name of the gourmet food chain would be updated on both servers.

The World Leader in SQL Server 2008 Training
Order SQL 2008 GRAND SLAM Today!
The Future is just a CLICK away! Your Future!
SQLUSA.com Home Page

Copyright 2005-2010, SMI Corp. All Rights Reserved.

SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.