sql server replication: What is the syntax for a no sync initialization when using scripts to =
create publication & subscription & subscription agent?

--=20

Thanx so much Paul!!!
Also true in sp_addpullsubscription ?

--=20
JLS
[quoted text, click to view]
@sync_type =3Dnone in sp_addsubscription.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:

Excellent! Thank you very much!!!

--=20
Jude
[quoted text, click to view]
No corresponding argument in sp_addpullsubscription. You could try =
using
sp_addsubscription with @subscription_type =3D '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:

@sync_type =3Dnone in sp_addsubscription.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:

No corresponding argument in sp_addpullsubscription. You could try using
sp_addsubscription with @subscription_type =3D '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:

How can I tell it that this is an anonymous pull subscription?

I am still pulling my hair out on getting a pull subscription from a =
machine out on the Internet.
- Network Alias is set on Subscriber
- Internet Sql Server can be registered on EM at Subscriber
- When trying to setup pull subscription on Subscriber, Internet server =
is present, but I get an error message about the Sql Agent Service =
account, when I try to browse for publications.

So, I tried to do a sp_addpullsubscription & =
sp_addpullsubscription_agent & this kind of worked, but I got an error =
message about the snapshot.
Hilary suggested I do a No sync (But I don't know where or how to do =
this in these scripts, I can't find an option)

Paul suggested I use sp_addsubscription with the type =3D 'pull', but =
this script doesn't allow me to tell it about my Publisher on the =
Internet.

I have felt like I am really close on getting this to work, and am maybe =
only missing 1 little piece of this puzzle, but I am just not getting =
it.

Please help!!!! I am getting to the point of where I will call someone =
& pay them (Microsoft I guess)

[quoted text, click to view]
No corresponding argument in sp_addpullsubscription. You could try =
using
sp_addsubscription with @subscription_type =3D '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: