Replacing a publisher with subscriber

SQL 2000
Currently, I have push transact replication with
immediate updates going out to several subscribers.
I want to take the publisher off the network and have a
subscriber become the publisher...
I will remove replication, and then delete the
field "msrepl_tran_version" from all of the published
tables.
Then I can install replication and push it out to the
subscribers.
I'm not using DRI.
Does this sound like the right plan?
Thanks,
Don
Yes, but what do you mean by "I'm not using DRI?"
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:038601c48edb$fd525570$a401280a@.phx.gbl...
> SQL 2000
> Currently, I have push transact replication with
> immediate updates going out to several subscribers.
> I want to take the publisher off the network and have a
> subscriber become the publisher...
> I will remove replication, and then delete the
> field "msrepl_tran_version" from all of the published
> tables.
> Then I can install replication and push it out to the
> subscribers.
> I'm not using DRI.
> Does this sound like the right plan?
> Thanks,
> Don
>
|||You'd mentioned in an earlier post of mine that if I was
using DRI than certain other steps would have to be done
regarding removing and setting up transact SQL.
Does that sound right?
Don
>--Original Message--
>Yes, but what do you mean by "I'm not using DRI?"
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"Don" <anonymous@.discussions.microsoft.com> wrote in
message
>news:038601c48edb$fd525570$a401280a@.phx.gbl...
>
>.
>

repl_distributor

If I click on the publication and look at the subscriber column the
subscriber name has changed to REPL_DISTRIBUTOR. Why is this and how do i
change it back to the name of the subscriber? Thank you in advance for your
help.
Exactly where are you seeing this? If I right click on my publication and
select properties, I see the Subscriptions and Subscription options tabs,
but nowhere a subscriber column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"golfnut" <golfnut@.discussions.microsoft.com> wrote in message
news:14A13BFA-52B1-45CF-B6E4-FA91F43B4BB2@.microsoft.com...
> If I click on the publication and look at the subscriber column the
> subscriber name has changed to REPL_DISTRIBUTOR. Why is this and how do i
> change it back to the name of the subscriber? Thank you in advance for
your
> help.
>

Repl problem with Identity Ranges?

I've given the automatic range on one of the tables for replication and I
entered
1000000 for publisher and 1000000 for subscriber.
When the table is replicated, the id column starts with 278418. Why does it
do this? does SQL know not to count? or am i missing something in
understanding?
I'm sorry. After some research, I found out that i missed something. Sorry
for the post.