Wednesday, March 7, 2012

Script (No Sync) syntax

What is the syntax for a no sync initialization when using scripts to create publication & subscription & subscription agent?
JLS
@.sync_type =none in sp_addsubscription.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanx so much Paul!!!
Also true in sp_addpullsubscription ?
JLS
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:umBvYgn%23FHA.1256@.TK2MSFTNGP15.phx.gbl...
@.sync_type =none in sp_addsubscription.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||No corresponding argument in sp_addpullsubscription. You could try using
sp_addsubscription with @.subscription_type = 'pull'. I've never set it up this way (always used push) but it seems the way to go.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Excellent! Thank you very much!!!
Jude
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uIN8Zmo%23FHA.1600@.TK2MSFTNGP11.phx.gbl...
No corresponding argument in sp_addpullsubscription. You could try using
sp_addsubscription with @.subscription_type = 'pull'. I've never set it up this way (always used push) but it seems the way to go.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment