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 |
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-09-27 : 10:45:23
|
Im trying to set up my snapshot to kick off at night which i can do by setting the job.But what i noticed is that if i add another table to the replication articles i have to click on the subscriptions and do reinitalize...........then the job can be schedule at night.How to do the reinitalize part automatically................ |
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-29 : 19:57:50
|
you can create job and run from there exec sp_reinitpullsubscription more:How to: Reinitialize a Subscription (Replication Transact-SQL Programming) http://msdn2.microsoft.com/en-us/library/ms146877.aspx |
|
|
|
|
|