Tuesday, March 20, 2012

replacate Inserts only

Running Win 2k & SQL 2k
How do I create or modify an already created publication
to only replacate Inserts?
Larry,
assuming you are using transactional replication, usually the way to
accomplish this is to change the command called to NONE on the article
properties. However this will force reinitialization of existing
subscriptions. In order to avoid reinitialization, you could modify the
stored procedure called - comment out the code in the update and delete
stored procedures.
HTH,
Paul Ibison
|||So, if the publications have not been created, I can
create them and change the command called to NONE on the
article properties for the delete and update, and this
should work...RIGHT?
Thanks,
Larry...
|||Larry - that's right
Paul
|||thanks, you da man!!!

No comments:

Post a Comment