Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2009-01-22 : 04:33:17
|
| Let's say, i've ABC system at ABC Location (using SQL Server 2000) and DEF System at DEF location (using Oracle).ABC System will insert the data, at the same time DEF System will update the data. How to guaranteed the entire set of operations completes, or the entire set of operations fails, and the state of the system is restored to the state it was in before any of the operations began. I believe there is an option for federated systems that needs to be setI heard about, Two-Phase commit. Any info and sample? Really need technical advice. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2009-01-22 : 07:30:36
|
| In such scenario, what you need is distributed transaction.Read about distributed transactions and two-phase commit here:http://msdn.microsoft.com/en-us/library/aa213077(SQL.80).aspxHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2009-01-23 : 03:51:15
|
| thanks for the great info |
|
|
|
|
|
|
Two-Phase commit