Change a Pull Subscription to a Push Subscription?

Is there a way to change a subscription from a Pull subscription to a Push
subscription without dropping it and creating a new one? This is in SQL
Server 2000 using transactional replication.
Thanks
No, not without considerable hacking, the likes of which I am unwilling to
even attempt
What you could do is kick everyone off your publication database, drop the
push subcription, create the pull subscription and then allow the users back
onto the publication database.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"John" <someone@.microsoft.com> wrote in message
news:eeD7UwJrEHA.2948@.TK2MSFTNGP11.phx.gbl...
> Is there a way to change a subscription from a Pull subscription to a Push
> subscription without dropping it and creating a new one? This is in SQL
> Server 2000 using transactional replication.
> Thanks
>

central subscriber

A central subscriber whose table is updated by multiple publishers and the
transactional push replication breaks on one of the publishers.
Does
a. If you do a new snapshot for that publisher does it automatically delete
the existing data in that table for that publisher assuming you have the
proper constraints in place for a unique column and then transactional
replication procedes as normal after the snapshot?
-or-
b. You have to wipe out the whole table and redo all the snapshots, i.e
reinitialize all the subscriptions.
-or-
c. something else
Any hard data in BOL,white papers, or other references to support either of
the possibilities?
a) But only if you user filters, and set up your name conflicts correctly.
To do this, right click on your publication, select properties, click on the articles tab, click on the browse button (the three dots) and then click on the snapshot tab. In the name conflicts section, pick delete all data that matches the row filter.
For Filters click on your Filter Commands tab, and add a filter condition. You might have to make changes to your schema to add a column which uniquely identifies your publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html