Groups | Blog | Home
all groups > sql server replication > august 2004 >

sql server replication : replacate Inserts only



larry
8/26/2004 10:31:39 AM
Running Win 2k & SQL 2k

How do I create or modify an already created publication
larry
8/26/2004 1:21:03 PM
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,
Paul Ibison
8/26/2004 7:57:29 PM
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

Paul Ibison
8/26/2004 11:15:42 PM
Larry - that's right :)
Paul

larry
8/27/2004 7:07:56 AM
AddThis Social Bookmark Button