changing distributors

Is it possible to change the distributor for a publisher without
affecting the publications?
Example:
D1 is SQL Server 2000 acting as distributor and publisher. X is SQL
Server 7.0 acting as a publisher. D1 pushes subscriptions to X and
also pulls subscriptions from X.
D2 is SQL Server 2000 and needs to act as the distributor, as well as
publisher. X is registered as a publisher with D2.
So here's the problem. I want D1 to continue pushing and pulling
subscriptions to and from X. However, I want D2 to be the distributor
for it. I don't care if D1 remains as a distributor or not. The
result should be that both D1 AND D2 push and pull subscriptions to
and from X, all being distributed by D2.
There is no supported way of doing this. You have to drop your publications,
make your change, recreate your publications and subscriptions.
"jsauri" <jeff_sauri@.hotmail.com> wrote in message
news:8c144331.0405061113.170d3b7a@.posting.google.c om...
> Is it possible to change the distributor for a publisher without
> affecting the publications?
> Example:
> D1 is SQL Server 2000 acting as distributor and publisher. X is SQL
> Server 7.0 acting as a publisher. D1 pushes subscriptions to X and
> also pulls subscriptions from X.
> D2 is SQL Server 2000 and needs to act as the distributor, as well as
> publisher. X is registered as a publisher with D2.
> So here's the problem. I want D1 to continue pushing and pulling
> subscriptions to and from X. However, I want D2 to be the distributor
> for it. I don't care if D1 remains as a distributor or not. The
> result should be that both D1 AND D2 push and pull subscriptions to
> and from X, all being distributed by D2.