> "no traditional RDBMS actually provide CAP consistency, for that they would have to use at least two-phase commit https://docs.microsoft.com/en-us/sql/t-sql/

> "no traditional RDBMS actually provide CAP consistency, for that they would have to use at least two-phase commit https://docs.microsoft.com/en-us/sql/t-sql/language-elements/commit-transaction-transact-sql https://docs.microsoft.com/en-us/sql/t-sql/language-elements... > If the transaction committed was a Transact-SQL distributed transaction, COMMIT TRANSACTION triggers MS DTC to use a two-phase commit protocol to commit all of the servers involved in the transaction. If a local transaction spans two or more databases on the same instance of the Database Engine, the instance uses an internal two-phase commit to commit all of the databases involved in the transaction. I'm only versed in SQL-Server but I'm pretty sure other RDBMS vendors provide similar functionality.