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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-21 : 08:08:11
|
| Jeff writes "I'm stumped. I keep seeing references to immediate and queued updating subscribers, but I'm never given an option to enable them. In the publication properties, I see updateable options, but they have a "No" locked in and I can't figure out how to change it. I've combed the articles, forums and books online, but I can;t find anywhere that this basic step is documented. Please help.Thanks,Jeff" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-21 : 08:50:32
|
Have you configured Merge Replication  Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2003-04-22 : 15:14:07
|
| He is referring to updating subscriptions for transactional replication, so configuring merge is not necessary. You have to enable queued and/or immediate updating when you create the publication. It cannot be enabled after the fact (hence the read-only No in the property sheet). I don't have SQL Server in front of me, but if memory serves, you need to select the show advanced options checkbox on the first page of the Create Publication Wizard. Then on a subsequent page you enable the publication for one or both. |
|
|
|
|
|
|
How do I enable updateable subscribers?