publication status

Here is what i get under sp_helpmergepublication :
status : 1
retention : 14
sync_mode : 0
allow_push : 1
allow_pull : 1
allow_anonymous : 1 <--
centralized_conflicts : 1
prority : 100.0
snapshot_ready : 0
publication_type : 0
pubid : (some value)
snapshot_jobid : (some value)
enabled_for_internet : 0
dynamic_filters : 0
has_subscription : 1
(...)
conflict_retention : 14
keep_partition_changes : 0
allow_subscription_copy : 0
allow_synctoalternate : 0
validate_subscriber_info : NULL
backward_comp_level : 40
publish_to_activeddirectory : 0
max_concurrent_merge : 0
max_concurrent_dynamic_snapshots : 0
"Hilary Cotter" wrote:
[vbcol=seagreen]
> If your publication is configured for anonymous subscribers the snapshot
> should always be ready and you should not have this problem.
> the
Is your subscriber anonymous or named?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nevrose" <Nevrose@.discussions.microsoft.com> wrote in message
news:F9C8C56F-6CBF-47B0-87E0-E2DDC9B3520D@.microsoft.com...[vbcol=seagreen]
> Here is what i get under sp_helpmergepublication :
> status : 1
> retention : 14
> sync_mode : 0
> allow_push : 1
> allow_pull : 1
> allow_anonymous : 1 <--
> centralized_conflicts : 1
> prority : 100.0
> snapshot_ready : 0
> publication_type : 0
> pubid : (some value)
> snapshot_jobid : (some value)
> enabled_for_internet : 0
> dynamic_filters : 0
> has_subscription : 1
> (...)
> conflict_retention : 14
> keep_partition_changes : 0
> allow_subscription_copy : 0
> allow_synctoalternate : 0
> validate_subscriber_info : NULL
> backward_comp_level : 40
> publish_to_activeddirectory : 0
> max_concurrent_merge : 0
> max_concurrent_dynamic_snapshots : 0
>
> "Hilary Cotter" wrote:
obtain[vbcol=seagreen]
|||Anonymous.
I have 2 suscribers.
Here is what i've got from sp_helpmergepullsubscription for both of them :
status 0 = All jobs are waiting to start
subscriber_type 3 = Anonymous
subscription_type 2 = Anonymous
priority 0.0
sync_type 1 = Automatic
enabled_for_synmgr 1
last_updated NULL
publisher_login NULL
publisher_password (nothing here)
publisher_security_mode 1 = Windows Authentication
distributor_login sa
distributor_password (nothing here)
distributor_security_mode 1 = Windows Authentication
use_ftp 0 = Subscription is not using FTP
offload_agent 0 = The agent cannot be remotely activated
use_interactive_resolver 0 = The interactive resolver is not used
dynamic_snapshot_location NULL
last_sync_status NULL (?, should be int)
last_sync_summary NULL
"Hilary Cotter" wrote:

> Is your subscriber anonymous or named?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Nevrose" <Nevrose@.discussions.microsoft.com> wrote in message
> news:F9C8C56F-6CBF-47B0-87E0-E2DDC9B3520D@.microsoft.com...
> obtain
>
>