column filter problem

Hi All:
I use merge replication in SQL server with column filter and row
filter , it works fine. so that i generate a script.
when i tried to run this script on another computer , i got warning
as below:
Warning: only Subscribers running SQL Server 2000 can synchronize with
publication 'eBreathe_Publication' because vertical filters are being used.
and say some tables doex not exist. i check all tables does exist
i just so confused , anyone know how to work it out?
Cheers
nick
Completed script as below:
-- Enabling the replication database
use master
GO
exec sp_replicationdboption @.dbname = N'eBreathe', @.optname = N'merge
publish', @.value = N'true'
GO
use [eBreathe]
GO
-- Adding the merge publication
exec sp_addmergepublication @.publication = N'eBreathe_Publication',
@.description = N'Merge publication of eBreathe database from Publisher
NICK.', @.retention = 30, @.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'eBreathe_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'NICK-eBreathe-eBreathe_Publication-1'
GO
exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
@.login = N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
@.login = N'distributor_admin'
GO
exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
@.login = N'NICK\IUSR_NICK'
GO
exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
@.login = N'sa'
GO
-- Adding the merge articles
exec sp_addmergearticle @.publication = N'eBreathe_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'SalesRepCode =
HOST_NAME()', @.vertical_partition = N'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerGroupCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerName', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerAddress1', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerAddress2', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerAddress3', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerPostCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'StateCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'CustomerCountry', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'SalesRepCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Customers', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_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'true',
@.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CustomerContact', @.column = N'CustomerContactCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CustomerContact', @.column = N'CustomerCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CustomerContact', @.column = N'CustomerContactName', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CustomerContact', @.column = N'CustomerContactPosition', @.operation =
N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CustomerContact', @.column = N'CustomerContactMobilePhone', @.operation =
N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_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
exec sp_addmergearticle @.publication = N'eBreathe_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'eBreathe_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 =
N'(CallObjective.IsDeleted = 0)', @.vertical_partition = N'true',
@.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CallObjective', @.column = N'CallObjectiveID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CallObjective', @.column = N'CallID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CallObjective', @.column = N'Description', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CallObjective', @.column = N'CallObjectiveStatusID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CallObjective', @.column = N'IsDeleted', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'CallObjective', @.column = N'LastModifiedBy', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_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'(Call.IsDeleted = 0)',
@.vertical_partition = N'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'CallID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'CustomerCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'ScheduleStarted', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'ScheduleEnded', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'ActualStarted', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'ActualEnded', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'CallStatusID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Call', @.column = N'IsDeleted', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_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'SalesRepCode =
HOST_NAME() AND (IsDisabled = 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'eBreathe_Publication', @.article =
N'TemplateLine', @.source_owner = N'dbo', @.source_object = N'TemplateLine',
@.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'eBreathe_Publication', @.article =
N'Template', @.source_owner = N'dbo', @.source_object = N'Template', @.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Template', @.column = N'TemplateID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Template', @.column = N'Description', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Template', @.column = N'CreationDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Template', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'SalesRep', @.source_owner = N'dbo', @.source_object = N'SalesRep', @.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'SalesRepCode =
HOST_NAME()', @.vertical_partition = N'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'SalesRepCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'SalesRepName', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'CompanyCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'SalesRepAddress', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'SalesRepCity', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'SalesRepPhone', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'SalesRepFax', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'NextOrderRef', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'SalesRep', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'ItemSubClass', @.source_owner = N'dbo', @.source_object = N'ItemSubClass',
@.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemSubClass', @.column = N'ItemSubClassCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemSubClass', @.column = N'ItemSubClassDescription', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemSubClass', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'Items', @.source_owner = N'dbo', @.source_object = N'Items', @.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemSubClassCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemGroupCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemClassCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemName', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemMeasureUnit', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'ItemUnitPrice', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'Items', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'ItemGroup', @.source_owner = N'dbo', @.source_object = N'ItemGroup', @.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemGroup', @.column = N'ItemGroupCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemGroup', @.column = N'ItemGroupDescription', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemGroup', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'ItemClass', @.source_owner = N'dbo', @.source_object = N'ItemClass', @.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemClass', @.column = N'ItemClassCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemClass', @.column = N'ItemClassDescription', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'ItemClass', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'InvoiceLine', @.source_owner = N'dbo', @.source_object = N'InvoiceLine',
@.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'InvoiceLineID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'InvoiceID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'LineID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'InvoiceItemID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'AppliedDocDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'AppliedAmount', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'CreationDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'EffectiveDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'ExpiryDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceLine', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'InvoiceHeader', @.source_owner = N'dbo', @.source_object = N'InvoiceHeader',
@.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'true', @.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's partition column(s)
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'InvoiceID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'InvoiceType', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'CustomerCode', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'ARDocDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'LinkTxnID', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'OriginalAmount', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'BalanceAmount', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'EffectiveDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'ExpiryDate', @.operation = N'add'
GO
exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication', @.article
= N'InvoiceHeader', @.column = N'rowguid', @.operation = N'add'
GO
exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
N'CustomerGroups', @.source_owner = N'dbo', @.source_object =
N'CustomerGroups', @.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'eBreathe_Publication', @.article =
N'BE_ItemCode', @.source_owner = N'dbo', @.source_object = N'BE_ItemCode',
@.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'eBreathe_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'eBreathe_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'eBreathe_Publication', @.article =
N'Call', @.filtername = N'Call_Customers', @.join_articlename = N'Customers',
@.join_filterclause = N'Call.CustomerCode = Customers.CustomerCode',
@.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'eBreathe_Publication', @.article =
N'InvoiceLine', @.filtername = N'InvoiceLine_InvoiceHeader',
@.join_articlename = N'InvoiceHeader', @.join_filterclause =
N'InvoiceHeader.InvoiceID = InvoiceLine.InvoiceID', @.join_unique_key = 0
GO
-- Adding the article subset filter
exec sp_addmergefilter @.publication = N'eBreathe_Publication', @.article =
N'InvoiceHeader', @.filtername = N'InvoiceHeader_Customers',
@.join_articlename = N'Customers', @.join_filterclause =
N'Customers.CustomerCode = InvoiceHeader.CustomerCode', @.join_unique_key = 0
GO
when we using column filter on certain tables that do not all primary key be
rowguid, is that this caused my problem?
because three tables cause error , which have one primary key as
uniqueidentifier and isRowGuid enable,
Cheers
nick
"Nick" <fsheng@.ebreathe.co.nz> wrote in message
news:OrEvGs$CFHA.3132@.TK2MSFTNGP09.phx.gbl...
> Hi All:
> I use merge replication in SQL server with column filter and row
> filter , it works fine. so that i generate a script.
> when i tried to run this script on another computer , i got warning
> as below:
> Warning: only Subscribers running SQL Server 2000 can synchronize with
> publication 'eBreathe_Publication' because vertical filters are being
used.
> and say some tables doex not exist. i check all tables does exist
> i just so confused , anyone know how to work it out?
> Cheers
> nick
> Completed script as below:
> -- Enabling the replication database
> use master
> GO
> exec sp_replicationdboption @.dbname = N'eBreathe', @.optname = N'merge
> publish', @.value = N'true'
> GO
> use [eBreathe]
> GO
> -- Adding the merge publication
> exec sp_addmergepublication @.publication = N'eBreathe_Publication',
> @.description = N'Merge publication of eBreathe database from Publisher
> NICK.', @.retention = 30, @.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'eBreathe_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'NICK-eBreathe-eBreathe_Publication-1'
> GO
> exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
> @.login = N'BUILTIN\Administrators'
> GO
> exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
> @.login = N'distributor_admin'
> GO
> exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
> @.login = N'NICK\IUSR_NICK'
> GO
> exec sp_grant_publication_access @.publication = N'eBreathe_Publication',
> @.login = N'sa'
> GO
> -- Adding the merge articles
> exec sp_addmergearticle @.publication = N'eBreathe_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'SalesRepCode =
> HOST_NAME()', @.vertical_partition = N'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerGroupCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerName', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerAddress1', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerAddress2', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerAddress3', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerPostCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'StateCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'CustomerCountry', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'SalesRepCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Customers', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_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'true',
> @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CustomerContact', @.column = N'CustomerContactCode', @.operation =
N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CustomerContact', @.column = N'CustomerCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CustomerContact', @.column = N'CustomerContactName', @.operation =
N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CustomerContact', @.column = N'CustomerContactPosition', @.operation =
> N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CustomerContact', @.column = N'CustomerContactMobilePhone', @.operation
=
> N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_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
> exec sp_addmergearticle @.publication = N'eBreathe_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'eBreathe_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 =
> N'(CallObjective.IsDeleted = 0)', @.vertical_partition = N'true',
> @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CallObjective', @.column = N'CallObjectiveID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CallObjective', @.column = N'CallID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CallObjective', @.column = N'Description', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CallObjective', @.column = N'CallObjectiveStatusID', @.operation =
N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CallObjective', @.column = N'IsDeleted', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'CallObjective', @.column = N'LastModifiedBy', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_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'(Call.IsDeleted = 0)',
> @.vertical_partition = N'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'CallID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'CustomerCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'ScheduleStarted', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'ScheduleEnded', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'ActualStarted', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'ActualEnded', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'CallStatusID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Call', @.column = N'IsDeleted', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_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'SalesRepCode =
> HOST_NAME() AND (IsDisabled = 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'eBreathe_Publication', @.article =
> N'TemplateLine', @.source_owner = N'dbo', @.source_object = N'TemplateLine',
> @.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'eBreathe_Publication', @.article =
> N'Template', @.source_owner = N'dbo', @.source_object = N'Template', @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Template', @.column = N'TemplateID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Template', @.column = N'Description', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Template', @.column = N'CreationDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Template', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'SalesRep', @.source_owner = N'dbo', @.source_object = N'SalesRep', @.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'SalesRepCode =
> HOST_NAME()', @.vertical_partition = N'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'SalesRepCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'SalesRepName', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'CompanyCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'SalesRepAddress', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'SalesRepCity', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'SalesRepPhone', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'SalesRepFax', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'NextOrderRef', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'SalesRep', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'ItemSubClass', @.source_owner = N'dbo', @.source_object = N'ItemSubClass',
> @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemSubClass', @.column = N'ItemSubClassCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemSubClass', @.column = N'ItemSubClassDescription', @.operation =
N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemSubClass', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'Items', @.source_owner = N'dbo', @.source_object = N'Items', @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemSubClassCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemGroupCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemClassCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemName', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemMeasureUnit', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'ItemUnitPrice', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'Items', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'ItemGroup', @.source_owner = N'dbo', @.source_object = N'ItemGroup', @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemGroup', @.column = N'ItemGroupCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemGroup', @.column = N'ItemGroupDescription', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemGroup', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'ItemClass', @.source_owner = N'dbo', @.source_object = N'ItemClass', @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemClass', @.column = N'ItemClassCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemClass', @.column = N'ItemClassDescription', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'ItemClass', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'InvoiceLine', @.source_owner = N'dbo', @.source_object = N'InvoiceLine',
> @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'InvoiceLineID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'InvoiceID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'LineID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'InvoiceItemID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'AppliedDocDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'AppliedAmount', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'CreationDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'EffectiveDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'ExpiryDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceLine', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'InvoiceHeader', @.source_owner = N'dbo', @.source_object =
N'InvoiceHeader',
> @.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'true', @.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's partition column(s)
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'InvoiceID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'InvoiceType', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'CustomerCode', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'ARDocDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'LinkTxnID', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'OriginalAmount', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'BalanceAmount', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'EffectiveDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'ExpiryDate', @.operation = N'add'
> GO
> exec sp_mergearticlecolumn @.publication = N'eBreathe_Publication',
@.article
> = N'InvoiceHeader', @.column = N'rowguid', @.operation = N'add'
> GO
> exec sp_addmergearticle @.publication = N'eBreathe_Publication', @.article =
> N'CustomerGroups', @.source_owner = N'dbo', @.source_object =
> N'CustomerGroups', @.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'eBreathe_Publication', @.article =
> N'BE_ItemCode', @.source_owner = N'dbo', @.source_object = N'BE_ItemCode',
> @.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'eBreathe_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'eBreathe_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'eBreathe_Publication', @.article =
> N'Call', @.filtername = N'Call_Customers', @.join_articlename =
N'Customers',
> @.join_filterclause = N'Call.CustomerCode = Customers.CustomerCode',
> @.join_unique_key = 0
> GO
> -- Adding the article subset filter
> exec sp_addmergefilter @.publication = N'eBreathe_Publication', @.article =
> N'InvoiceLine', @.filtername = N'InvoiceLine_InvoiceHeader',
> @.join_articlename = N'InvoiceHeader', @.join_filterclause =
> N'InvoiceHeader.InvoiceID = InvoiceLine.InvoiceID', @.join_unique_key = 0
> GO
> -- Adding the article subset filter
> exec sp_addmergefilter @.publication = N'eBreathe_Publication', @.article =
> N'InvoiceHeader', @.filtername = N'InvoiceHeader_Customers',
> @.join_articlename = N'Customers', @.join_filterclause =
> N'Customers.CustomerCode = InvoiceHeader.CustomerCode', @.join_unique_key =
0
> GO
>
>
>