SQL transaction rollback and commit

[ppp001]

Hi all, I have a problem for data transactions across two databases. That is one object's data is comprised of two tables from two different databases. I can perform rollback and commit within one database. But for this case, how can I perform rollback and commit across two databases(for two different SQL connections) for the object ? Thanks

[David Salter]

You need to use a two phase commit mechanism. What database are you using?

---

Database FAQ