Cross-Library transactions

Unless MS DTC is currently installed on the computer running the "the Database Engine" This instance example an Error message. For more information on installing MS DTC, see the Microsoft distributed Transaction Coordinator documentation.

Use AdventureWorks2012; Gobegin distributed transaction;--Delete candidate from local instance. Delete AdventureWorks2012.HumanResources.JobCandidate WHERE Jobcandidateid = 13;--Delete candidate from remote Instanc E.delete RemoteServer.AdventureWorks2012.HumanResources.JobCandidate WHERE Jobcandidateid = 13; COMMIT TRANSACTION; GO

Cross-Library transactions