> No, you can't do it without a massive amount of hacking.
>
>

"Combfilter" <adsf@asdf.com> wrote in message
news:MPG.1b97bf009123ebe49896a3@news.newsreader.com...
> This is for transactional replication.
>
> I have a publisher (sqlA) using a distributors
> (replA) that is pushing to subscriber (subA).
> (sqlA) ---> (replA) ---> (subA)
>
> I want to keep the publisher and subscriber the
> same and want to switch the distributor without
> reinitialization. So the end result would be.
>
> (sqlA) ---> (replB) ---> (subA).
>
> I am not a sql guru so this would need to be done
> within Enterprise Manager.
>
> TIA.
> -comb

"Combfilter" <adsf@asdf.com> wrote in message
news:MPG.1b97cef9bba6787c9896a4@news.newsreader.com...
> In article <#U8WFZ4iEHA.3664
> @TK2MSFTNGP12.phx.gbl>, hilaryk@att.net says...
> > No, you can't do it without a massive amount of hacking.
> >
> >
> damn.. ok thanks.
>
> I guess my next question is, what is the best way
> to do what I need to do? Just change the
> distributor and the restart snapshot agents? Or
> will I even have to do snapshot agents since a
> snapshot had already been applied before.
>
> Thanks,

> The best way to do this is to drop the publications, and subcriptions,
> disable publishing on the publisher, enable the distributor server as a
> distributor and allow the publisher to publish to it. Then enable publishing
> on the publisher and configure it to use the remote distributor. Then
> recreate your publications and subscriptions.
>
>