Question : I’m not sure about distributed transaction coordinator so please bare with me on this, I’m probably asking this […]
Tag: distributed-transactions
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 […]
Oracle temporary table usage with XA
Question : I’m confused about the compatibility of Oracle XA with global temporary tables. I’ve read several places on the […]
MS SQL 2017 cluster: impact of disabling distributed transactions for an availability group
Question : A company is having a Microsoft SQL Server 2017 Enterprise cluster (RTM-GDR, 64-bit, 14.0.2027.2, KB4505224) consisting of one […]
- 1
- 2