VietMX Staff asked 3 years ago
- A transaction is considered to be a local transaction when it is a single-phase transaction and is handled by the database directly.
- A transaction is considered to be a distributed transaction when it is coordinated by a transaction monitor and uses fail-safe mechanisms (such as two-phase commit) for transaction resolution. Essentially a distributed transaction is a transaction that affects several resources.
Transactions are most efficient when they are performed on the server. If you are working with a SQL Server database that makes extensive use of explicit transactions, consider writing them as stored procedures using the Transact-SQL BEGIN TRANSACTION statement.
