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

sql server replication : recreating pull named subscription



taghreed
12/12/2004 10:02:10 AM
I'm using stored procedures to recreate an old subscription:
sp_addsubscription
sp_addpullsubscription
sp_addpullsubscription_agent
I have to use transactional sql as this is part of installation package
to setup my application.
The problem is:
I cannot find the option in these SPs where I can choose not to
initialize the subscriber (Subscriber already has schema and data)
This option is supported in normal wizard. I suppose stored procedures
should cover all sql options.

Thanks alot,
Taghreed
Paul Ibison
12/12/2004 7:08:22 PM
In sp_addsubscription set @sync_type = none.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button