sql server replication: Adding Subscribers with @sync_type = N'none' -- sql server replication

Adding Subscribers with @sync_type = N'none'

Darin
9/29/2003 5:37:06 PM

sql server replication:

Hello,

Here's my question. I'm adding transactional replication
and replicating 6 tables. But the servers that I'm
replicating too have the same schema and data so I don't
want the snapshot agent to run when adding the subscribers
as it will fail with PK violations.

So, easy enough, I just sent the parameter @sync_type
to 'none' when running 'sp_addsubscription' and that
works. But then I modified some data and the distribution
agents failed. Upon investigation, it seems that when I
set @sync_type to 'none', the publisher is not copying
over the @ins_cmd, @del_cmd and @upd_cmd sprocs that were
defined when I created the articles (but it does if I set
@sync_type to 'automatic').

Is there a setting I'm missing that will prevent the
snapshot agent from running but will copy the sprocs over
to the subscribers? I simply want to add transactional
replication, not perform the initial snapshot (being the
tables are already in sync) and then replicate over any
changes to the tables.

TIA!!

Re: Adding Subscribers with @sync_type = N'none'

Greg Yvkoff [MSFT]
9/30/2003 10:31:47 AM

Take a look at:

sp_scriptpublicationcustomprocs

Thanks.
greg

[quoted text, click to view]