Transaction Server

  • Thread starter Thread starter George Varelas
  • Start date Start date
G

George Varelas

Imagine that we have one SQL server 2000 and 2 databases A and B. Obviously
I need two connections. I want to implement a transaction that controls two
insertions, one in each database. The transaction commits when both the
insertions are succesfull. I know that I need MSDTC. Is it enough to start
the appropriate service. If yes could someone give me a code sample that
implements this transaction with the MSDTC as intermediate in C#. That would
help a lot.

Thank you in advance
 
George Varelas said:
Imagine that we have one SQL server 2000 and 2 databases A and B. Obviously
I need two connections. I want to implement a transaction that controls two
insertions, one in each database. The transaction commits when both the
insertions are succesfull. I know that I need MSDTC. Is it enough to start
the appropriate service. If yes could someone give me a code sample that
implements this transaction with the MSDTC as intermediate in C#. That would
help a lot.

Thank you in advance
Click to expand...

Search in msdn docs about COM+ and enterpriseservices (using COM+ from NET).
It is very simple (the transactions are declarative)
 
Back
Top