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 |
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-15 : 14:48:23
|
COULD ANY ONE TELL ME WHETHER TRANSACTIONAL REPLICATION WITH UPDATABLE SUBSCRIBERS IS ONE WAY COMMITMENT OR TWO WAY COMMITMENT AND WHAT IS THE DIFFERENCE BETWEEN THEM |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-15 : 22:42:12
|
One phase commitment, sql will queue transactions if subscriber is not available. In two-phase commitment, transaction can be committed only if both servers are available. |
|
|
|
|
|