A snapshot was not generated because no subscriptions needed initi

Full error I am getting: a snapshot was not generated because no
subscriptions needed initialization
Scenario: I run the New Publication Wizard to create and add a
Transactional Publication with Updateable Subscriptions to my SQL Server. I
choose the script option at the end of the Wizard and save the script that
the Wizard generates. The publication is created fine and an initial snapshot
is created for the publication. Obviously I have no Subscribers to the
Publication yet...I just created it, but the Snapshot is created without
issue. That's cool, that's what is wanted.
The Problem: Now, if the Publication is Deleted from the SQL
Server(successfully...no errors & no funkiness), and I then run the script
that the Wizard created for me, the initial Snapshot does not get created as
it did thru the Wizard, but everything else involving the script is fine. I
get the aforementioned error at the top of this message. This sucks. Isn't
this script supposed to do exactly what I just did in the Wizard? I want the
Snapshot created in the same fashion as it was when the Wizard did it. What
is going on that is different between the Wizard and the script that the
Wizard created (and something must be different)? I did not alter the
script in any way from what the Wizard gave me. Is there some trick or
workaround to get this behavior? Am I missing the boat on something here?
Thanks.
Chris Jones
Application Development Consultant
Chris,
Check to see if the sp_addpublication in the generated script has the
parameter @.immediate_sync set to 'true'.
When creating the publication if the immediate sync property is set to
'true', a snapshot for the publication will be generated everytime the
snapshot agent runs even if the publication doesn't have any
subscriptions....else if @.immediate_sync is set to 'false', the snapshot
will not be generated because the publication does not have any subscriptions
yet.
HTH
Emaniel
"Chris" wrote:

> Full error I am getting: a snapshot was not generated because no
> subscriptions needed initialization
> Scenario: I run the New Publication Wizard to create and add a
> Transactional Publication with Updateable Subscriptions to my SQL Server. I
> choose the script option at the end of the Wizard and save the script that
> the Wizard generates. The publication is created fine and an initial snapshot
> is created for the publication. Obviously I have no Subscribers to the
> Publication yet...I just created it, but the Snapshot is created without
> issue. That's cool, that's what is wanted.
> The Problem: Now, if the Publication is Deleted from the SQL
> Server(successfully...no errors & no funkiness), and I then run the script
> that the Wizard created for me, the initial Snapshot does not get created as
> it did thru the Wizard, but everything else involving the script is fine. I
> get the aforementioned error at the top of this message. This sucks. Isn't
> this script supposed to do exactly what I just did in the Wizard? I want the
> Snapshot created in the same fashion as it was when the Wizard did it. What
> is going on that is different between the Wizard and the script that the
> Wizard created (and something must be different)? I did not alter the
> script in any way from what the Wizard gave me. Is there some trick or
> workaround to get this behavior? Am I missing the boat on something here?
> --
> Thanks.
> Chris Jones
> Application Development Consultant