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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-12-03 : 09:43:51
|
| Hello ,Do i have to re-initialize the publication if i add some articles in the publication . I checked that once you add articles in the publication , the new articles are not replicated to the destination once the snapshot is started manually . So i guess , the publication needs to be re-initiliazed . Is that so ? I have SQL 7.0 with SP4 . Thanks |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-12-03 : 10:08:24
|
| Should work. Do you have PULL subscriptions? If so, check out sp_refreshsubscriptions in SQL Server Books Online.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2002-12-03 : 10:41:58
|
| Hello Vyas ,Thanks for your reply .Its a transactional push replication . Will the sp_refreshsubcriptions work for Push replication also ? BOL says that it only works when you have pull subscription .Thanks once again.Admin001 |
|
|
|
|
|
|
Re-initialize publication.