default replication mechanism

Hi,
I did'n want to use default replication mechanism when I initially set up
transactional replication between 2 servers (sql server 2000 sp3). However,
now I need to change replication to use default mechanism for some operations
(inserts/updates/deletes) of existing articles.
1. Is there any way to do that without dropping whole publication (for the
articles which didn't replicate updates to the other side)?
2. Also, is there any way to generate sp_MSins... stored procedures without
synchronizing data between publisher and subsciber (option "created stored
procedures during initial synchronization of subscriptions")? I have 2 large
databases, and initializing subscriptions (synchronizing data) just to
generate these stored procedures wouldn't make lot of sense.
Thanks
Pedja,
here's the answer to the second question:
http://msdn2.microsoft.com/en-us/library/ms187946.aspx
For the first question, I'm not quite sure what you're asking. Do you want
to add an article to an existing publication? If so, you can do this from
the GUI, run the snapshot agent and synchronize. This will just add the new
article and not reinitialize the others.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks for the answer.
For the first question, since I replicated inserts, but not delets and
updates in the old setup, these two fields are grayed (unavailable). What I
am asking is is there a way to enable them (check them to use generated
stored procedures), without droping and recreating publication (unchecking
and checking just that article doesn't work)?
"Paul Ibison" wrote:

> Pedja,
> here's the answer to the second question:
> http://msdn2.microsoft.com/en-us/library/ms187946.aspx
> For the first question, I'm not quite sure what you're asking. Do you want
> to add an article to an existing publication? If so, you can do this from
> the GUI, run the snapshot agent and synchronize. This will just add the new
> article and not reinitialize the others.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Pedja,
not as far as I know. I think your best bet would be to do a nosync
initialization.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)