Friday, February 10, 2012

Before merging,validate subscribers with this expression

Hello,
Could someone explain me what it meens.
I have made 2 merge publications with dynamic filters: suser_sname()
The first one does not validate subcriber before the synchronisation
The second one validate with 'suser_sname()'
I do not see differences between the 2 replication, and i do not exactly
understand what it means.
Thank you.
Courtoisement
Pierre-Marie PETIT
pm@.nst.fr
03 20 06 63 94
can you script out your publication and subscription and post it here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"pm" <pm@.nst.fr> wrote in message
news:uPfNCExnEHA.3428@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Could someone explain me what it meens.
> I have made 2 merge publications with dynamic filters: suser_sname()
> The first one does not validate subcriber before the synchronisation
> The second one validate with 'suser_sname()'
> I do not see differences between the 2 replication, and i do not exactly
> understand what it means.
> Thank you.
> --
> Courtoisement
> Pierre-Marie PETIT
> pm@.nst.fr
> 03 20 06 63 94
>
|||Here is the only differences between the 2 publications
(you can see that it is only here: @.validate_subscriber_info =
N'suser_sname()' Thie parameters is not in the second Tsql code)
So i do not understand what is this parameter for @.validate_subscriber_info
exec sp_addmergepublication @.publication =
N'pub_SYNERGY_Dyn_UserFilter_validation', @.description = N'Pub avec Filtre
sur le user et validation des donnes', @.retention = 14, @.sync_mode =
N'native', @.allow_push = N'true', @.allow_pull = N'true', @.allow_anonymous =
N'false', @.enabled_for_internet = N'false', @.centralized_conflicts =
N'true', @.dynamic_filters = N'true', @.snapshot_in_defaultfolder = N'true',
@.compress_snapshot = N'false', @.ftp_port = 21, @.ftp_login = N'anonymous',
@.conflict_retention = 14, @.keep_partition_changes = N'true',
@.allow_subscription_copy = N'false', @.allow_synctoalternate = N'false',
@.validate_subscriber_info = N'suser_sname()', @.add_to_active_directory =
N'false', @.max_concurrent_merge = 0, @.max_concurrent_dynamic_snapshots = 0
exec sp_addmergepublication @.publication = N'pub_SYNERGY_Dyn_UserFilter',
@.description = N'Pub avec Filtre sur le user (qui ne doit pas faire partie
du compte admin de sql)', @.retention = 14, @.sync_mode = N'native',
@.allow_push = N'true', @.allow_pull = N'true', @.allow_anonymous = N'false',
@.enabled_for_internet = N'false', @.centralized_conflicts = N'true',
@.dynamic_filters = N'true', @.snapshot_in_defaultfolder = N'true',
@.compress_snapshot = N'false', @.ftp_port = 21, @.ftp_login = N'anonymous',
@.conflict_retention = 14, @.keep_partition_changes = N'true',
@.allow_subscription_copy = N'false', @.allow_synctoalternate = N'false',
@.add_to_active_directory = N'false', @.max_concurrent_merge = 0,
@.max_concurrent_dynamic_snapshots = 0
"Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
news:%23cPKwUxnEHA.3396@.tk2msftngp13.phx.gbl...
> can you script out your publication and subscription and post it here?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "pm" <pm@.nst.fr> wrote in message
> news:uPfNCExnEHA.3428@.TK2MSFTNGP11.phx.gbl...
>

No comments:

Post a Comment