MS SQL Server - Distributed transaction

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Distributed transaction

silvia.fama@googlemail.com

2006-10-24, 6:30 pm

Hi!
I'm studiyng Distributed Transaction on different databases.
On Sql Server, distributed transaction are managed by MS DTC, infact
"prepare" sql statement doesn't exist cause MS DTC manages it when a
"commit" is performed.

Is there a way to manage a distributed transaction with two phase
commit protocol (start distributed transaction, prepare, commit and
rollback statement) without let MS DTC to manage the transaction?

Infact I'm trying to implement a function that works with Oracle,
Sybase and Sql Server for distributed transaction and I'd like to use
the prepare statement.

Thank you!

Sponsored Links