From: Marcel de on
Forgot to mention, we run SQLServer on a machine PC, not on a server. For server purposes this wouldn't work unless you restart the SQLServer regularly.



Marcel de Vries wrote:

RE: Thanks for the reply. Maybe I am looking at the wrong thing then.
10-May-10

I'm having the same problem.
I have now changed the folling thing.
When you create a publicication in RMO, you can set the schedule for a snapshot.

publication.SnapshotSchedule.FrequencyType = ScheduleFrequencyType.Continuously;

I've set the frequencytype to Continuously. This way the snapshot is taken when sqlserver starts.
In our case this was a solution because we don't have a really large database, so maybe it also working for you.

Good luck!

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorials/aspnet/77429274-e89f-49c2-a93a-b290f013f649/entity-framework-40-and.aspx