Thursday, March 8, 2012

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
>

No comments:

Post a Comment