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 |
|
genji
Starting Member
2 Posts |
 Posted - 2010-02-23 : 15:25:21
|
| Hi, could somebody clarify how the @update_mode parameter of the sp_addsubscription procedure works please?Specifically, I am confused becuase this parmeter seems to allow a subscriber to send updates to a publisher using transactional type repliction. I had assumed only merge type replication allowed updates at the subscriber to be propergated to the publisher. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-23 : 20:42:49
|
| For transactional replication (without updating subscribers) @update_mode is read only |
 |
|
|
genji
Starting Member
2 Posts |
Posted - 2010-02-25 : 07:23:01
|
| Thankyou russell.So I am correct is assuming the other values (sync tran, queued tran, failover, queued failover) for the @update_mode parameter are only used in merge replication? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 14:04:56
|
| yes. |
|
|
|
|
|
|
sp_addsubscription @update_mode