Question : I run the following update, which is one single transaction across 2 databases. Please note I have not […]
Tag: distributed-transactions
Does openquery use distributed transactions?
Question : Does openquery in SQL Server 2005 use distributed transactions? If so, in which cases does it? Answer : […]
Distributed transaction coordinator between SQL Server and Oracle
Question : I’m not sure about distributed transaction coordinator so please bare with me on this, I’m probably asking this […]
Where do Linked Server Queries get executed?
Question : I have two instances ServerA and ServerB, and I have created a linked server in ServerA for ServerB […]
Distributed transaction coordinator between SQL Server and Oracle
Question : I’m not sure about distributed transaction coordinator so please bare with me on this, I’m probably asking this […]
Auto-commit UPDATE Transaction On Linked Server
Question : I would like to know more about what happens behind the scenes with an auto-commit transaction when performing […]
Does Azure MySQL 8 service with region HA support XA transactions?
Question : I need to configure a MySQL cluster in Azure with region HA that supports XA transactions. MySQL does […]
Insert into linked server fails with “The transaction manager has disabled its support for remote/network transactions”
Question : Two servers: sq009 and sq202, both running SQL Server 2012 SP3. sq202 is the SQL Server hosting the […]
SQL Server Distributed Transactions: xp_sqljdbc_xa_commit vs xp_sqljdbc_xa_end
Question : In SQL Server 2019, can anyone definitively tell me the functional difference between xp_sqljdbc_xa_commit & xp_sqljdbc_xa_end? My guess […]
Automatically rollback two-phase transactions on session disconnect
Question : I’m using two-phase commit in Postgres to reliably work with an external system (Amazon EC2). I.e. I first […]
- 1
- 2