sql server replication: 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))
[quoted text, click to view]
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 =

What exactly is the error ? I couldn't find it in your post...

--=20
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"


[quoted text, click to view]
HI all

I am using merge replication for mobile. the publication has 39 =
table=20
and one of talbe call products, my pocket pc can down snapshot =
database=20
sucessfully when product table without row filter. it always =
occurs=20
"run" error if i set a row filter (product.productInactive=3D0) in =
products=20
table.

Below is script........please sb can help me out here, i been =
stuck here=20
for a week.

Thanks



/****** Begin: Script to be run at Distributor: NICK ******/
/****** Installing the server Nick as a Distributor. Script Date: =
2/23/2005=20
1:26:58 PM ******/
use master
GO

exec sp_adddistributor @distributor =3D N'EBREATHEDEMO', @password =
=3D N''
GO

-- Updating the agent profile defaults
sp_MSupdate_agenttype_default @profile_id =3D 1
GO
sp_MSupdate_agenttype_default @profile_id =3D 2
GO
sp_MSupdate_agenttype_default @profile_id =3D 4
GO
sp_MSupdate_agenttype_default @profile_id =3D 6
GO
sp_MSupdate_agenttype_default @profile_id =3D 11
GO

-- Adding the distribution database
exec sp_adddistributiondb @database =3D N'MSALES_Distribution', =
@data_folder=20
=3D N'C:\Program Files\Microsoft SQL Server\MSSQL\Data', @data_file =
=3D=20
N'MSALES_Distribution.MDF', @data_file_size =3D 2, @log_folder =3D =
N'C:\Program=20
Files\Microsoft SQL Server\MSSQL\Data', @log_file =3D=20
N'MSALES_Distribution.LDF', @log_file_size =3D 0, @min_distretention =
=3D 0,=20
@max_distretention =3D 1, @history_retention =3D 48, @security_mode =
=3D 1
GO

-- Adding the distribution publisher
exec sp_adddistpublisher @publisher =3D N'EBREATHEDEMO', =
@distribution_db =3D=20
N'MSALES_Distribution', @security_mode =3D 1, @working_directory =3D=20
N'\\EBREATHEDEMO\C$\Program Files\Microsoft SQL =
Server\MSSQL\ReplData',=20
@trusted =3D N'false', @thirdparty_flag =3D 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 =3D N'MSALES', @optname =3D =
N'merge=20
publish', @value =3D N'true'
GO

use [MSALES]
GO

-- Adding the merge publication
exec sp_addmergepublication @publication =3D N'MSALES_Publication',=20
@description =3D N'Merge publication of MSALES database from Publisher =

EBREATHEDEMO.', @retention =3D 14, @sync_mode =3D N'character', =
@allow_push =3D=20
N'true', @allow_pull =3D N'true', @allow_anonymous =3D N'true',=20
@enabled_for_internet =3D N'false', @centralized_conflicts =3D =
N'true',=20
@dynamic_filters =3D N'true', @snapshot_in_defaultfolder =3D N'true',=20
@compress_snapshot =3D N'false', @ftp_port =3D 21, @ftp_login =3D =
N'anonymous',=20
@conflict_retention =3D 14, @keep_partition_changes =3D N'true',=20
@allow_subscription_copy =3D N'false', @allow_synctoalternate =3D =
N'false',=20
@validate_subscriber_info =3D N'HOST_NAME()', @add_to_active_directory =
=3D=20
N'false', @max_concurrent_merge =3D 0, =
@max_concurrent_dynamic_snapshots =3D 0
exec sp_addpublication_snapshot @publication =3D=20
N'MSALES_Publication',@frequency_type =3D 4, @frequency_interval =3D =
1,=20
@frequency_relative_interval =3D 1, @frequency_recurrence_factor =3D =
0,=20
@frequency_subday =3D 1, @frequency_subday_interval =3D 5, =
@active_start_date =3D=20
0, @active_end_date =3D 0, @active_start_time_of_day =3D 500,=20
@active_end_time_of_day =3D 235959, @snapshot_job_name =3D=20
N'EBREATHEDEMO-MSALES-MSALES_Publication-1'
GO

exec sp_grant_publication_access @publication =3D =
N'MSALES_Publication',=20
@login =3D N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access @publication =3D =
N'MSALES_Publication',=20
@login =3D N'distributor_admin'
GO
exec sp_grant_publication_access @publication =3D =
N'MSALES_Publication',=20
@login =3D N'eBreathe'
GO



-- Adding the merge articles
exec sp_addmergearticle @publication =3D N'MSALES_Publication', =
@article =3D=20
N'QALockedProduct', @source_owner =3D N'dbo', @source_object =3D=20
N'QALockedProduct', @type =3D N'table', @description =3D null, =
@column_tracking=20
=3D N'true', @pre_creation_cmd =3D N'drop', @creation_script =3D null, =

@schema_option =3D 0x000000000000CFF1, @article_resolver =3D null,=20
@subset_filterclause =3D null, @vertical_partition =3D N'false',=20
@destination_owner =3D N'dbo', @auto_identity_range =3D N'false',=20
@verify_resolver_signature =3D 0, @allow_interactive_resolver =3D =
N'false',=20
@fast_multicol_updateproc =3D N'true', @check_permissions =3D 0
GO
exec sp_addmergearticle @publication =3D N'MSALES_Publication', =
@article =3D=20
N'CustomerDistributor', @source_owner =3D N'dbo', @source_object =3D=20
N'CustomerDistributor', @type =3D N'table', @description =3D null,=20
@column_tracking =3D N'true', @pre_creation_cmd =3D N'drop', =
@creation_script =3D=20
null, @schema_option =3D 0x000000000000CFF1, @article_resolver =3D =
null,=20
@subset_filterclause =3D null, @vertical_partition =3D N'false',=20
@destination_owner =3D N'dbo', @auto_identity_range =3D N'false',=20
@verify_resolver_signature =3D 0, @allow_interactive_resolver =3D =
N'false',=20
@fast_multicol_updateproc =3D N'true', @check_permissions =3D 0
GO
exec sp_addmergearticle @publication =3D N'MSALES_Publication', =
@article =3D=20
N'BonusDealFlavour', @source_owner =3D N'dbo', @source_object =3D=20
N'BonusDealFlavour', @type =3D N'table', @description =3D null, =
@column_tracking=20
=3D N'true', @pre_creation_cmd =3D N'drop', @creation_script =3D null, =

@schema_option =3D 0x000000000000CFF1, @article_resolver =3D null,=20
@subset_filterclause =3D null, @vertical_partition =3D N'false',=20
@destination_owner =3D N'dbo', @auto_identity_range =3D N'false',=20
@verify_resolver_signature =3D 0, @allow_interactive_resolver =3D =
N'false',=20
@fast_multicol_updateproc =3D N'true', @check_permissions =3D 0
GO
exec sp_addmergearticle @publication =3D N'MSALES_Publication', =
@article =3D=20
N'DistributorProductFlavour', @source_owner =3D N'dbo', @source_object =
=3D=20
N'DistributorProductFlavour', @type =3D N'table', @description =3D =
null,=20
@column_tracking =3D N'true', @pre_creation_cmd =3D N'drop', =
@creation_script =3D=20
null, @schema_option =3D 0x000000000000CFF1, @article_resolver =3D =
null,=20
@subset_filterclause =3D null, @vertical_partition =3D N'false',=20