row filter

HI all
I am using merge replication for mobile. the publication has 39 table
and one of talbe call products, my pocket pc can down snapshot database
sucessfully when product table without row filter. it always occurs
"run" error if i set a row filter (product.productInactive=0) in products
table.
Below is script......please sb can help me out here, i been stuck here
for a week.
Thanks
/****** Begin: Script to be run at Distributor: NICK ******/
/****** Installing the server Nick as a Distributor. Script Date: 2/23/2005
1:26:58 PM ******/
use master
GO
exec sp_adddistributor @.distributor = N'EBREATHEDEMO', @.password = N''
GO
-- Updating the agent profile defaults
sp_MSupdate_agenttype_default @.profile_id = 1
GO
sp_MSupdate_agenttype_default @.profile_id = 2
GO
sp_MSupdate_agenttype_default @.profile_id = 4
GO
sp_MSupdate_agenttype_default @.profile_id = 6
GO
sp_MSupdate_agenttype_default @.profile_id = 11
GO
-- Adding the distribution database
exec sp_adddistributiondb @.database = N'MSALES_Distribution', @.data_folder
= N'C:\Program Files\Microsoft SQL Server\MSSQL\Data', @.data_file =
N'MSALES_Distribution.MDF', @.data_file_size = 2, @.log_folder = N'C:\Program
Files\Microsoft SQL Server\MSSQL\Data', @.log_file =
N'MSALES_Distribution.LDF', @.log_file_size = 0, @.min_distretention = 0,
@.max_distretention = 1, @.history_retention = 48, @.security_mode = 1
GO
-- Adding the distribution publisher
exec sp_adddistpublisher @.publisher = N'EBREATHEDEMO', @.distribution_db =
N'MSALES_Distribution', @.security_mode = 1, @.working_directory =
N'\\EBREATHEDEMO\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData',
@.trusted = N'false', @.thirdparty_flag = 0
GO
/****** End: Script to be run at Distributor: NICK ******/
/****** Begin: Script to be run at Publisher: NICK ******/
-- Enabling the replication database
use master
GO
exec sp_replicationdboption @.dbname = N'MSALES', @.optname = N'merge
publish', @.value = N'true'
GO
use [MSALES]
GO
-- Adding the merge publication
exec sp_addmergepublication @.publication = N'MSALES_Publication',
@.description = N'Merge publication of MSALES database from Publisher
EBREATHEDEMO.', @.retention = 14, @.sync_mode = N'character', @.allow_push =
N'true', @.allow_pull = N'true', @.allow_anonymous = N'true',
@.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'HOST_NAME()', @.add_to_active_directory =
N'false', @.max_concurrent_merge = 0, @.max_concurrent_dynamic_snapshots = 0
exec sp_addpublication_snapshot @.publication =
N'MSALES_Publication',@.frequency_type = 4, @.frequency_interval = 1,
@.frequency_relative_interval = 1, @.frequency_recurrence_factor = 0,
@.frequency_subday = 1, @.frequency_subday_interval = 5, @.active_start_date =
0, @.active_end_date = 0, @.active_start_time_of_day = 500,
@.active_end_time_of_day = 235959, @.snapshot_job_name =
N'EBREATHEDEMO-MSALES-MSALES_Publication-1'
GO
exec sp_grant_publication_access @.publication = N'MSALES_Publication',
@.login = N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access @.publication = N'MSALES_Publication',
@.login = N'distributor_admin'
GO
exec sp_grant_publication_access @.publication = N'MSALES_Publication',
@.login = N'eBreathe'
GO
-- Adding the merge articles
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALockedProduct', @.source_owner = N'dbo', @.source_object =
N'QALockedProduct', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CustomerDistributor', @.source_owner = N'dbo', @.source_object =
N'CustomerDistributor', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavour', @.source_owner = N'dbo', @.source_object =
N'BonusDealFlavour', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'DistributorProductFlavour', @.source_owner = N'dbo', @.source_object =
N'DistributorProductFlavour', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAMaximumFlavour', @.source_owner = N'dbo', @.source_object =
N'QAMaximumFlavour', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= BeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <=
EndDate)', @.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealState', @.source_owner = N'dbo', @.source_object =
N'BonusDealState', @.type = N'table', @.description = null, @.column_tracking =
N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductState', @.source_owner = N'dbo', @.source_object =
N'BonusDealProductState', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CustomerContact', @.source_owner = N'dbo', @.source_object =
N'CustomerContact', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALockedType', @.source_owner = N'dbo', @.source_object = N'QALockedType',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause =
N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) >= BeginDate) AND
(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <= EndDate)',
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAMaximumProductDetail', @.source_owner = N'dbo', @.source_object =
N'QAMaximumProductDetail', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductCondition', @.source_owner = N'dbo', @.source_object =
N'BonusDealProductCondition', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealCondition', @.source_owner = N'dbo', @.source_object =
N'BonusDealCondition', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductFlavour', @.source_owner = N'dbo', @.source_object =
N'ProductFlavour', @.type = N'table', @.description = null, @.column_tracking =
N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'ProductFlavourInactive=0', @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductGroupBannerDistributorState', @.source_owner = N'dbo',
@.source_object = N'ProductGroupBannerDistributorState', @.type = N'table',
@.description = null, @.column_tracking = N'true', @.pre_creation_cmd =
N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductFlavourGiveOut', @.source_owner = N'dbo', @.source_object =
N'BonusDealProductFlavourGiveOut', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavourGiveOut', @.source_owner = N'dbo', @.source_object =
N'BonusDealFlavourGiveOut', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALockedBanner', @.source_owner = N'dbo', @.source_object =
N'QALockedBanner', @.type = N'table', @.description = null, @.column_tracking =
N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Customers', @.source_owner = N'dbo', @.source_object = N'Customers', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'(Customers.CustomerInactive=0)AND (CAST(RepCode AS
NVARCHAR)=HOST_NAME())', @.vertical_partition = N'false', @.destination_owner
= N'dbo', @.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAMaximumProduct', @.source_owner = N'dbo', @.source_object =
N'QAMaximumProduct', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= BeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <=
EndDate)', @.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProduct', @.source_owner = N'dbo', @.source_object =
N'BonusDealProduct', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= BeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <=
EndDate)', @.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDeal', @.source_owner = N'dbo', @.source_object = N'BonusDeal', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) >= BeginDate) AND
(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <= EndDate)',
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
--exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Users', @.source_owner = N'dbo', @.source_object = N'Users', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = N'CAST(RepCode AS
NVARCHAR)=HOST_NAME()', @.vertical_partition = N'false', @.destination_owner =
N'dbo', @.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
--GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'DistributorWarehouse', @.source_owner = N'dbo', @.source_object =
N'DistributorWarehouse', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALocked', @.source_owner = N'dbo', @.source_object = N'QALocked', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Products', @.source_owner = N'dbo', @.source_object = N'Products', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'Products.ProductInactive=0', @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'DistributorState', @.source_owner = N'dbo', @.source_object =
N'DistributorState', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'SpecialState', @.source_owner = N'dbo', @.source_object = N'SpecialState',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause =
N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) >= SpecialBeginDate) AND
(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <= SpecialEndDate)',
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Flavours', @.source_owner = N'dbo', @.source_object = N'Flavours', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BannerGroups', @.source_owner = N'dbo', @.source_object = N'BannerGroups',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CreditReason', @.source_owner = N'dbo', @.source_object = N'CreditReason',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Call', @.source_owner = N'dbo', @.source_object = N'Call', @.type = N'table',
@.description = null, @.column_tracking = N'true', @.pre_creation_cmd =
N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'(DATEADD(day, -60,CONVERT(DATETIME, CONVERT(NVARCHAR, GETDATE(),10))) <
CONVERT(DATETIME, CONVERT(NVARCHAR, ScheduleStarted,10))) AND
(CAST(LastModifiedBy AS NVARCHAR)=HOST_NAME())', @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CallObjectiveStatus', @.source_owner = N'dbo', @.source_object =
N'CallObjectiveStatus', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAType', @.source_owner = N'dbo', @.source_object = N'QAType', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'States', @.source_owner = N'dbo', @.source_object = N'States', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'SpecialNational', @.source_owner = N'dbo', @.source_object =
N'SpecialNational', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= SpecialBeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
<= SpecialEndDate)', @.vertical_partition = N'false', @.destination_owner =
N'dbo', @.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductGroups', @.source_owner = N'dbo', @.source_object = N'ProductGroups',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductBrands', @.source_owner = N'dbo', @.source_object = N'ProductBrands',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductGroupOrder', @.source_owner = N'dbo', @.source_object =
N'ProductGroupOrder', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CallObjective', @.source_owner = N'dbo', @.source_object = N'CallObjective',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CallStatus', @.source_owner = N'dbo', @.source_object = N'CallStatus', @.type
= N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QALockedProduct', @.filtername = N'QALockedProduct_QALocked',
@.join_articlename = N'QALocked', @.join_filterclause =
N'QALockedProduct.DistributorCode = QALocked.DistributorCode AND
QALockedProduct.StateCode = QALocked.StateCode AND QALockedProduct.QADealNo
= QALocked.QADealNo', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'CustomerDistributor', @.filtername = N'CustomerDistributor_Customers',
@.join_articlename = N'Customers', @.join_filterclause =
N'CustomerDistributor.CustomerCode = Customers.CustomerCode',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavour', @.filtername = N'FK_BonusDealFlavour_BonusDeal',
@.join_articlename = N'BonusDeal', @.join_filterclause =
N'[BonusDealFlavour].[ProductCode] = [BonusDeal].[ProductCode] and
[BonusDealFlavour].[BonusDealNo] = [BonusDeal].[BonusDealNo]',
@.join_unique_key = 1
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'DistributorProductFlavour', @.filtername =
N'DistributorProductFlavour_ProductFlavour', @.join_articlename =
N'ProductFlavour', @.join_filterclause =
N'[DistributorProductFlavour].[ProductCode] = [ProductFlavour].[ProductCode]
and [DistributorProductFlavour].[FlavourCode] =
[ProductFlavour].[FlavourCode]', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealState', @.filtername = N'FK_BonusDealState_BonusDeal',
@.join_articlename = N'BonusDeal', @.join_filterclause =
N'[BonusDealState].[ProductCode] = [BonusDeal].[ProductCode] and
[BonusDealState].[BonusDealNo] = [BonusDeal].[BonusDealNo]',
@.join_unique_key = 1
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductState', @.filtername =
N'BonusDealProductState_BonusDealProduct', @.join_articlename =
N'BonusDealProduct', @.join_filterclause =
N'BonusDealProductState.Productcode = BonusDealProduct.ProductCode AND
BonusDealProductState.BonusDealNo = BonusDealProduct.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'CustomerContact', @.filtername = N'CustomerContact_Customers',
@.join_articlename = N'Customers', @.join_filterclause =
N'CustomerContact.CustomerCode = Customers.CustomerCode', @.join_unique_key =
0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QAMaximumProductDetail', @.filtername =
N'QAMaximumProductDetail_QAMaximumProduct', @.join_articlename =
N'QAMaximumProduct', @.join_filterclause =
N'QAMaximumProductDetail.ProductCode = QAMaximumProduct.ProductCode AND
QAMaximumProductDetail.QAMaxTermNo = QAMaximumProduct.QAMaxTermNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductCondition', @.filtername =
N'BonusDealProductCondition_BonusDealProduct', @.join_articlename =
N'BonusDealProduct', @.join_filterclause =
N'BonusDealProductCondition.ProductCode = BonusDealProduct.ProductCode AND
BonusDealProductCondition.BonusDealNo = BonusDealProduct.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealCondition', @.filtername = N'FK_BonusDealCondition_BonusDeal',
@.join_articlename = N'BonusDeal', @.join_filterclause =
N'[BonusDealCondition].[ProductCode] = [BonusDeal].[ProductCode] and
[BonusDealCondition].[BonusDealNo] = [BonusDeal].[BonusDealNo]',
@.join_unique_key = 1
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductFlavourGiveOut', @.filtername =
N'BonusDealProductFlavourGiveOut_BonusDealProduct' , @.join_articlename =
N'BonusDealProduct', @.join_filterclause =
N'BonusDealProduct.ProductCode=BonusDealProductFla vourGiveOut.ProductCode
AND
BonusDealProduct.BonusDealNo=BonusDealProductFlavo urGiveOut.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavourGiveOut', @.filtername =
N'BonusDealFlavourGiveOut_BonusDeal', @.join_articlename = N'BonusDeal',
@.join_filterclause =
N'BonusDeal.ProductCode=BonusDealFlavourGiveOut.Pr oductCode AND
BonusDeal.BonusDealNo = BonusDealFlavourGiveOut.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QALockedBanner', @.filtername = N'QALockedBanner_QALocked',
@.join_articlename = N'QALocked', @.join_filterclause =
N'QALockedBanner.DistributorCode = QALocked.DistributorCode AND
QALockedBanner.StateCode = QALocked.StateCode AND QALockedBanner.QADealNo =
QALocked.QADealNo', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QALocked', @.filtername = N'QALocked_QALockedType', @.join_articlename =
N'QALockedType', @.join_filterclause =
N'QALockedType.DistributorCode=QALocked.Distributo rCode AND
QALockedType.StateCode=QALocked.StateCode AND
QALockedType.QADealNo=QALocked.QADealNo', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'CallObjective', @.filtername = N'CallObjective_Call', @.join_articlename =
N'Call', @.join_filterclause = N'CallObjective.CallID = Call.CallID',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'Products', @.filtername = N'Products_ProductFlavour', @.join_articlename =
N'ProductFlavour', @.join_filterclause = N'Products.ProductCode =
ProductFlavour.ProductCode', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'ProductFlavour', @.filtername = N'ProductFlavour_Products',
@.join_articlename = N'Products', @.join_filterclause = N'Products.ProductCode
= ProductFlavour.ProductCode', @.join_unique_key = 0
GO
/****** End: Script to be run at Publisher: NICK ******/
What exactly is the error ? I couldn't find it in your post...
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"victor" <gshi@.ebreathe.co.nz> wrote in message news:uSSB6LgIFHA.588@.TK2MSFTNGP15.phx.gbl...
HI all
I am using merge replication for mobile. the publication has 39 table
and one of talbe call products, my pocket pc can down snapshot database
sucessfully when product table without row filter. it always occurs
"run" error if i set a row filter (product.productInactive=0) in products
table.
Below is script......please sb can help me out here, i been stuck here
for a week.
Thanks
/****** Begin: Script to be run at Distributor: NICK ******/
/****** Installing the server Nick as a Distributor. Script Date: 2/23/2005
1:26:58 PM ******/
use master
GO
exec sp_adddistributor @.distributor = N'EBREATHEDEMO', @.password = N''
GO
-- Updating the agent profile defaults
sp_MSupdate_agenttype_default @.profile_id = 1
GO
sp_MSupdate_agenttype_default @.profile_id = 2
GO
sp_MSupdate_agenttype_default @.profile_id = 4
GO
sp_MSupdate_agenttype_default @.profile_id = 6
GO
sp_MSupdate_agenttype_default @.profile_id = 11
GO
-- Adding the distribution database
exec sp_adddistributiondb @.database = N'MSALES_Distribution', @.data_folder
= N'C:\Program Files\Microsoft SQL Server\MSSQL\Data', @.data_file =
N'MSALES_Distribution.MDF', @.data_file_size = 2, @.log_folder = N'C:\Program
Files\Microsoft SQL Server\MSSQL\Data', @.log_file =
N'MSALES_Distribution.LDF', @.log_file_size = 0, @.min_distretention = 0,
@.max_distretention = 1, @.history_retention = 48, @.security_mode = 1
GO
-- Adding the distribution publisher
exec sp_adddistpublisher @.publisher = N'EBREATHEDEMO', @.distribution_db =
N'MSALES_Distribution', @.security_mode = 1, @.working_directory =
N'\\EBREATHEDEMO\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData',
@.trusted = N'false', @.thirdparty_flag = 0
GO
/****** End: Script to be run at Distributor: NICK ******/
/****** Begin: Script to be run at Publisher: NICK ******/
-- Enabling the replication database
use master
GO
exec sp_replicationdboption @.dbname = N'MSALES', @.optname = N'merge
publish', @.value = N'true'
GO
use [MSALES]
GO
-- Adding the merge publication
exec sp_addmergepublication @.publication = N'MSALES_Publication',
@.description = N'Merge publication of MSALES database from Publisher
EBREATHEDEMO.', @.retention = 14, @.sync_mode = N'character', @.allow_push =
N'true', @.allow_pull = N'true', @.allow_anonymous = N'true',
@.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'HOST_NAME()', @.add_to_active_directory =
N'false', @.max_concurrent_merge = 0, @.max_concurrent_dynamic_snapshots = 0
exec sp_addpublication_snapshot @.publication =
N'MSALES_Publication',@.frequency_type = 4, @.frequency_interval = 1,
@.frequency_relative_interval = 1, @.frequency_recurrence_factor = 0,
@.frequency_subday = 1, @.frequency_subday_interval = 5, @.active_start_date =
0, @.active_end_date = 0, @.active_start_time_of_day = 500,
@.active_end_time_of_day = 235959, @.snapshot_job_name =
N'EBREATHEDEMO-MSALES-MSALES_Publication-1'
GO
exec sp_grant_publication_access @.publication = N'MSALES_Publication',
@.login = N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access @.publication = N'MSALES_Publication',
@.login = N'distributor_admin'
GO
exec sp_grant_publication_access @.publication = N'MSALES_Publication',
@.login = N'eBreathe'
GO
-- Adding the merge articles
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALockedProduct', @.source_owner = N'dbo', @.source_object =
N'QALockedProduct', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CustomerDistributor', @.source_owner = N'dbo', @.source_object =
N'CustomerDistributor', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavour', @.source_owner = N'dbo', @.source_object =
N'BonusDealFlavour', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'DistributorProductFlavour', @.source_owner = N'dbo', @.source_object =
N'DistributorProductFlavour', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAMaximumFlavour', @.source_owner = N'dbo', @.source_object =
N'QAMaximumFlavour', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= BeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <=
EndDate)', @.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealState', @.source_owner = N'dbo', @.source_object =
N'BonusDealState', @.type = N'table', @.description = null, @.column_tracking =
N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductState', @.source_owner = N'dbo', @.source_object =
N'BonusDealProductState', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CustomerContact', @.source_owner = N'dbo', @.source_object =
N'CustomerContact', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALockedType', @.source_owner = N'dbo', @.source_object = N'QALockedType',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause =
N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) >= BeginDate) AND
(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <= EndDate)',
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAMaximumProductDetail', @.source_owner = N'dbo', @.source_object =
N'QAMaximumProductDetail', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductCondition', @.source_owner = N'dbo', @.source_object =
N'BonusDealProductCondition', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealCondition', @.source_owner = N'dbo', @.source_object =
N'BonusDealCondition', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductFlavour', @.source_owner = N'dbo', @.source_object =
N'ProductFlavour', @.type = N'table', @.description = null, @.column_tracking =
N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'ProductFlavourInactive=0', @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductGroupBannerDistributorState', @.source_owner = N'dbo',
@.source_object = N'ProductGroupBannerDistributorState', @.type = N'table',
@.description = null, @.column_tracking = N'true', @.pre_creation_cmd =
N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductFlavourGiveOut', @.source_owner = N'dbo', @.source_object =
N'BonusDealProductFlavourGiveOut', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavourGiveOut', @.source_owner = N'dbo', @.source_object =
N'BonusDealFlavourGiveOut', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALockedBanner', @.source_owner = N'dbo', @.source_object =
N'QALockedBanner', @.type = N'table', @.description = null, @.column_tracking =
N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Customers', @.source_owner = N'dbo', @.source_object = N'Customers', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'(Customers.CustomerInactive=0)AND (CAST(RepCode AS
NVARCHAR)=HOST_NAME())', @.vertical_partition = N'false', @.destination_owner
= N'dbo', @.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAMaximumProduct', @.source_owner = N'dbo', @.source_object =
N'QAMaximumProduct', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= BeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <=
EndDate)', @.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDealProduct', @.source_owner = N'dbo', @.source_object =
N'BonusDealProduct', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= BeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <=
EndDate)', @.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BonusDeal', @.source_owner = N'dbo', @.source_object = N'BonusDeal', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) >= BeginDate) AND
(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <= EndDate)',
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
--exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Users', @.source_owner = N'dbo', @.source_object = N'Users', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = N'CAST(RepCode AS
NVARCHAR)=HOST_NAME()', @.vertical_partition = N'false', @.destination_owner =
N'dbo', @.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
--GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'DistributorWarehouse', @.source_owner = N'dbo', @.source_object =
N'DistributorWarehouse', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QALocked', @.source_owner = N'dbo', @.source_object = N'QALocked', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Products', @.source_owner = N'dbo', @.source_object = N'Products', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'Products.ProductInactive=0', @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'DistributorState', @.source_owner = N'dbo', @.source_object =
N'DistributorState', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'SpecialState', @.source_owner = N'dbo', @.source_object = N'SpecialState',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause =
N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) >= SpecialBeginDate) AND
(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10)) <= SpecialEndDate)',
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Flavours', @.source_owner = N'dbo', @.source_object = N'Flavours', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'BannerGroups', @.source_owner = N'dbo', @.source_object = N'BannerGroups',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CreditReason', @.source_owner = N'dbo', @.source_object = N'CreditReason',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'Call', @.source_owner = N'dbo', @.source_object = N'Call', @.type = N'table',
@.description = null, @.column_tracking = N'true', @.pre_creation_cmd =
N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause =
N'(DATEADD(day, -60,CONVERT(DATETIME, CONVERT(NVARCHAR, GETDATE(),10))) <
CONVERT(DATETIME, CONVERT(NVARCHAR, ScheduleStarted,10))) AND
(CAST(LastModifiedBy AS NVARCHAR)=HOST_NAME())', @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CallObjectiveStatus', @.source_owner = N'dbo', @.source_object =
N'CallObjectiveStatus', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'QAType', @.source_owner = N'dbo', @.source_object = N'QAType', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'States', @.source_owner = N'dbo', @.source_object = N'States', @.type =
N'table', @.description = null, @.column_tracking = N'true', @.pre_creation_cmd
= N'drop', @.creation_script = null, @.schema_option = 0x000000000000CFF1,
@.article_resolver = null, @.subset_filterclause = null, @.vertical_partition =
N'false', @.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'SpecialNational', @.source_owner = N'dbo', @.source_object =
N'SpecialNational', @.type = N'table', @.description = null, @.column_tracking
= N'true', @.pre_creation_cmd = N'drop', @.creation_script = null,
@.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = N'(CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
>= SpecialBeginDate) AND (CONVERT(DATETIME,CONVERT(VARCHAR, GETDATE(),10))
<= SpecialEndDate)', @.vertical_partition = N'false', @.destination_owner =
N'dbo', @.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductGroups', @.source_owner = N'dbo', @.source_object = N'ProductGroups',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductBrands', @.source_owner = N'dbo', @.source_object = N'ProductBrands',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'ProductGroupOrder', @.source_owner = N'dbo', @.source_object =
N'ProductGroupOrder', @.type = N'table', @.description = null,
@.column_tracking = N'true', @.pre_creation_cmd = N'drop', @.creation_script =
null, @.schema_option = 0x000000000000CFF1, @.article_resolver = null,
@.subset_filterclause = null, @.vertical_partition = N'false',
@.destination_owner = N'dbo', @.auto_identity_range = N'false',
@.verify_resolver_signature = 0, @.allow_interactive_resolver = N'false',
@.fast_multicol_updateproc = N'true', @.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CallObjective', @.source_owner = N'dbo', @.source_object = N'CallObjective',
@.type = N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
exec sp_addmergearticle @.publication = N'MSALES_Publication', @.article =
N'CallStatus', @.source_owner = N'dbo', @.source_object = N'CallStatus', @.type
= N'table', @.description = null, @.column_tracking = N'true',
@.pre_creation_cmd = N'drop', @.creation_script = null, @.schema_option =
0x000000000000CFF1, @.article_resolver = null, @.subset_filterclause = null,
@.vertical_partition = N'false', @.destination_owner = N'dbo',
@.auto_identity_range = N'false', @.verify_resolver_signature = 0,
@.allow_interactive_resolver = N'false', @.fast_multicol_updateproc = N'true',
@.check_permissions = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QALockedProduct', @.filtername = N'QALockedProduct_QALocked',
@.join_articlename = N'QALocked', @.join_filterclause =
N'QALockedProduct.DistributorCode = QALocked.DistributorCode AND
QALockedProduct.StateCode = QALocked.StateCode AND QALockedProduct.QADealNo
= QALocked.QADealNo', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'CustomerDistributor', @.filtername = N'CustomerDistributor_Customers',
@.join_articlename = N'Customers', @.join_filterclause =
N'CustomerDistributor.CustomerCode = Customers.CustomerCode',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavour', @.filtername = N'FK_BonusDealFlavour_BonusDeal',
@.join_articlename = N'BonusDeal', @.join_filterclause =
N'[BonusDealFlavour].[ProductCode] = [BonusDeal].[ProductCode] and
[BonusDealFlavour].[BonusDealNo] = [BonusDeal].[BonusDealNo]',
@.join_unique_key = 1
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'DistributorProductFlavour', @.filtername =
N'DistributorProductFlavour_ProductFlavour', @.join_articlename =
N'ProductFlavour', @.join_filterclause =
N'[DistributorProductFlavour].[ProductCode] = [ProductFlavour].[ProductCode]
and [DistributorProductFlavour].[FlavourCode] =
[ProductFlavour].[FlavourCode]', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealState', @.filtername = N'FK_BonusDealState_BonusDeal',
@.join_articlename = N'BonusDeal', @.join_filterclause =
N'[BonusDealState].[ProductCode] = [BonusDeal].[ProductCode] and
[BonusDealState].[BonusDealNo] = [BonusDeal].[BonusDealNo]',
@.join_unique_key = 1
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductState', @.filtername =
N'BonusDealProductState_BonusDealProduct', @.join_articlename =
N'BonusDealProduct', @.join_filterclause =
N'BonusDealProductState.Productcode = BonusDealProduct.ProductCode AND
BonusDealProductState.BonusDealNo = BonusDealProduct.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'CustomerContact', @.filtername = N'CustomerContact_Customers',
@.join_articlename = N'Customers', @.join_filterclause =
N'CustomerContact.CustomerCode = Customers.CustomerCode', @.join_unique_key =
0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QAMaximumProductDetail', @.filtername =
N'QAMaximumProductDetail_QAMaximumProduct', @.join_articlename =
N'QAMaximumProduct', @.join_filterclause =
N'QAMaximumProductDetail.ProductCode = QAMaximumProduct.ProductCode AND
QAMaximumProductDetail.QAMaxTermNo = QAMaximumProduct.QAMaxTermNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductCondition', @.filtername =
N'BonusDealProductCondition_BonusDealProduct', @.join_articlename =
N'BonusDealProduct', @.join_filterclause =
N'BonusDealProductCondition.ProductCode = BonusDealProduct.ProductCode AND
BonusDealProductCondition.BonusDealNo = BonusDealProduct.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealCondition', @.filtername = N'FK_BonusDealCondition_BonusDeal',
@.join_articlename = N'BonusDeal', @.join_filterclause =
N'[BonusDealCondition].[ProductCode] = [BonusDeal].[ProductCode] and
[BonusDealCondition].[BonusDealNo] = [BonusDeal].[BonusDealNo]',
@.join_unique_key = 1
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealProductFlavourGiveOut', @.filtername =
N'BonusDealProductFlavourGiveOut_BonusDealProduct' , @.join_articlename =
N'BonusDealProduct', @.join_filterclause =
N'BonusDealProduct.ProductCode=BonusDealProductFla vourGiveOut.ProductCode
AND
BonusDealProduct.BonusDealNo=BonusDealProductFlavo urGiveOut.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'BonusDealFlavourGiveOut', @.filtername =
N'BonusDealFlavourGiveOut_BonusDeal', @.join_articlename = N'BonusDeal',
@.join_filterclause =
N'BonusDeal.ProductCode=BonusDealFlavourGiveOut.Pr oductCode AND
BonusDeal.BonusDealNo = BonusDealFlavourGiveOut.BonusDealNo',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QALockedBanner', @.filtername = N'QALockedBanner_QALocked',
@.join_articlename = N'QALocked', @.join_filterclause =
N'QALockedBanner.DistributorCode = QALocked.DistributorCode AND
QALockedBanner.StateCode = QALocked.StateCode AND QALockedBanner.QADealNo =
QALocked.QADealNo', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'QALocked', @.filtername = N'QALocked_QALockedType', @.join_articlename =
N'QALockedType', @.join_filterclause =
N'QALockedType.DistributorCode=QALocked.Distributo rCode AND
QALockedType.StateCode=QALocked.StateCode AND
QALockedType.QADealNo=QALocked.QADealNo', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'CallObjective', @.filtername = N'CallObjective_Call', @.join_articlename =
N'Call', @.join_filterclause = N'CallObjective.CallID = Call.CallID',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'Products', @.filtername = N'Products_ProductFlavour', @.join_articlename =
N'ProductFlavour', @.join_filterclause = N'Products.ProductCode =
ProductFlavour.ProductCode', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'MSALES_Publication', @.article =
N'ProductFlavour', @.filtername = N'ProductFlavour_Products',
@.join_articlename = N'Products', @.join_filterclause = N'Products.ProductCode
= ProductFlavour.ProductCode', @.join_unique_key = 0
GO
/****** End: Script to be run at Publisher: NICK ******/