Re: Can u turn on replication dynamically

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 10/03/04

  • Next message: Hilary Cotter: "Re: Logreader agent not being created" 
    Date: Sat, 2 Oct 2004 22:26:43 -0400

    as a subscriber MSDE will support all replication types. As a publisher, it
    can only be a merge publisher. 

    -- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jake" <rondican@hotmail.com> wrote in message
news:uovTKiOqEHA.3936@TK2MSFTNGP10.phx.gbl...
> Hilary,
>
>     Do you have a suggestion/preference on which type or replication to
use?
> Will MSDE support merge?
>
> Jake
>
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:eV27gLOqEHA.3896@TK2MSFTNGP15.phx.gbl...
> > you can use sp_start_job (found in the msdb database) to start the
> pull/push
> > job.
> >
> > -- 
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Jake" <rondican@hotmail.com> wrote in message
> > news:%23tciV$KqEHA.3396@tk2msftngp13.phx.gbl...
> > > Hello,
> > >
> > >     We have a MSDE subscription that resides on a mobile computer. We
> > > currently have the pull subscription jobs scheduled to run from 1am
till
> > > 5pm. This synchronizes the data well. However we are wondering if
there
> is
> > a
> > > way to manipulate the jobs scheduled time to start whenever we chose.
So
> > the
> > > idea is (if possible) we have another job scheduled ever 15 min on the
> > MSDE
> > > it will read a table that has three columns (lastupdated, starttime,
> > > updated) This job will read and compare the updated and lastupdated
> > columns
> > > if the updated is > lastupdated it takes the start time and
manipulates
> > the
> > > pull subscriptions job's start time. How can we do this? Would we then
> > need
> > > to restart SQL Agent? Any suggestions would be greatly appreciated.
> > >
> > > Jake
> > >
> > >
> >
> >
>
>
  • Next message: Hilary Cotter: "Re: Logreader agent not being created"

    Relevant Pages

    • Re: QUEUE READER - A FREQUENT PROBLEM!
      ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... queue table and the same transaction coldn't be inserted at the ...
      (microsoft.public.sqlserver.replication)
    • Re: Merge Replication-Pull Subscription-Error?
      ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... "JOB HISTORY" says the following: ...
      (microsoft.public.sqlserver.replication)
    • Re: Data Transfer via Email
      ... Hilary Cotter ... Looking for a SQL Server replication book? ...
      (microsoft.public.sqlserver.replication)
    • Re: Replication with SqlServer and MSDE
      ... You can set up replication with one SQL Server and multiple MSDE instances. ... how replication works with Identity fields (I insert a Order in my laptop ...
      (microsoft.public.sqlserver.programming)
    • Re: Replication between MSDE and SQL Server 2000
      ... replication process between the SQL Server 2000 and the laptop MSDE? ... As I am investigating the database to do this project, MSDE is an option, ... The reason why I need to do the replication is the sales persons bring the ...
      (microsoft.public.sqlserver.replication)
    Loading