You can also use distributed transactions whenever there's SQL Server to SQL Server communication and changes will be made to data during the course of the transaction, often done via a linked server.

Is it possible to use linked services in MSSQL Server and execute queries if the Distributed Transaction Coordinator is not enabled?Maybe this should be in the NT forum, but I thought writing ...