Row level filtering (does not need to be secure)

I'm trying to design a system where I can filter (not secure) a users results, the user may or may not pass in a user ID. We typically use middle tier connection pooling with a single identity, so I believe labelling is not suitable.

I think the ideal solution would be...

User to establishes a connection through our application, a user id will be established as part of the connection. A view is created describing what the user is able to access. Preferably the user should not be aware of the view. The user or our application executes a number of select queries.

Note that there may be many users with different filters required connecting at any time.

Direct user updates of the table do not need to be supported.

This topic comes up on the forums from time to time in the context of row level security.

The following whitepaper may also be useful to you:

http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

It uses labeling but I think your solution will require something like that because you are pushing an id for the user down to SQL Server from the middle tier.

HTH,

-Steven Gott

S/DET

SQL Server

row filter where clause (busy db performance hit?)

Hello.
I need to setup a filter for a really busy db
that we are replicating. I was wondering what
type of filter to use. I am afraid that the
where clause of a row filter will create a major
performance hit. I was looking into dts and
Transformable Subscriptions but am not real clear
if that would be better.
any advice would be appreciated.
thanks,
-comb
Would this be a static filter or a dynamic filter, ie where store_id=2
(static) or where store_id=hostname() (dynamic)?
There is more processing involved in using filters. The impact may vary
widely.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1c0e66c5405f97bc9896ef@.news.newsreader.co m...
> Hello.
> I need to setup a filter for a really busy db
> that we are replicating. I was wondering what
> type of filter to use. I am afraid that the
> where clause of a row filter will create a major
> performance hit. I was looking into dts and
> Transformable Subscriptions but am not real clear
> if that would be better.
> any advice would be appreciated.
> thanks,
> -comb
|||In article <OmLTYxk0EHA.1932
@.TK2MSFTNGP09.phx.gbl>, hilary.cotter@.gmail.com
says...
> Would this be a static filter or a dynamic filter, ie where store_id=2
> (static) or where store_id=hostname() (dynamic)?
> There is more processing involved in using filters. The impact may vary
> widely.
>
it's static. where fkstoreid in (5001,5002)
like that.
-comb
|||is fkstoreid indexed?
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1c0e87f9669ff2889896f0@.news.newsreader.co m...
> In article <OmLTYxk0EHA.1932
> @.TK2MSFTNGP09.phx.gbl>, hilary.cotter@.gmail.com
> says...
> it's static. where fkstoreid in (5001,5002)
> like that.
> -comb
|||In article <#qRjNSl0EHA.3072
@.TK2MSFTNGP11.phx.gbl>, hilary.cotter@.gmail.com
says...
> is fkstoreid indexed?
>
yes
|||This filter probably is optimal.
You might want to look at replicating the execution of stored procedures -
this can lead to radical performance increases.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1c0ea5cf51e7c2e59896f1@.news.newsreader.co m...
> In article <#qRjNSl0EHA.3072
> @.TK2MSFTNGP11.phx.gbl>, hilary.cotter@.gmail.com
> says...
> yes
|||In article <OP2$6Gv0EHA.3368
@.TK2MSFTNGP10.phx.gbl>, hilary.cotter@.gmail.com
says...
> This filter probably is optimal.
> You might want to look at replicating the execution of stored procedures -
> this can lead to radical performance increases.
>
thanks,
-comb

Row filter vs join filter

Hi,
I am new to replication, I am confusing with row filter and join filter. If
I only use row filter, does the SQL server replication caused any data
integrity problem? e.g. simple relationship of such table tblCustomer,
tblOrder and tblOrderDetail?
Thank you.
HKM
a row filter normally means you filter by a column on a row with a value.
Ie in the authors table a row filter would look like this
where state='ca'
When you do a join filter you are joining on another table for your
filtering criteria.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"HKM" <HKM@.discussions.microsoft.com> wrote in message
news:F05A0678-7A6B-49F3-82D0-0C4EA60AB0D4@.microsoft.com...
> Hi,
> I am new to replication, I am confusing with row filter and join filter.
If
> I only use row filter, does the SQL server replication caused any data
> integrity problem? e.g. simple relationship of such table tblCustomer,
> tblOrder and tblOrderDetail?
> Thank you.
> HKM

Row Filter not working

I have a snapshot/transactional replication publication with the following
row filter:
SELECT <published_columns> FROM <<TABLE>> WHERE ItemName
not in ('dbsvrip','otfrconn','mapdir') and AppTypeID<>7
The snapshot generated just fine, but now none of the changes to the table
are getting replicated.
I'm using sql2000.
Any ideas?
I resolved this problem by changing the WHERE CLAUSE to:
Itemname<>'dbsvrip' and Itemname<>'otfrconn' and Itemname<>'mapdir' and
AppTypeID<>7.
"Need more Zzzz" wrote:

> I have a snapshot/transactional replication publication with the following
> row filter:
> SELECT <published_columns> FROM <<TABLE>> WHERE ItemName
> not in ('dbsvrip','otfrconn','mapdir') and AppTypeID<>7
> The snapshot generated just fine, but now none of the changes to the table
> are getting replicated.
> I'm using sql2000.
> Any ideas?
>

row filter in chiliren table

Yes - joins and filters are often used together,
especially in merge.
Rgds,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
hi paul:
so how about i set row fitlers at parent and set row filters at
children, does this work as well? what i thought is the children level
row fitler won't work if it's parent has row filters
, is that right?
Cheer
Nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:039a01c53504$51ba43b0$a401280a@.phx.gbl...
> Yes - joins and filters are often used together,
> especially in merge.
> Rgds,
> Paul Ibison SQL Server MVP,
> www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Nick,
what you've hit on is v.interesting and is something that
I'll look into in more detail. A combination of parent
filter, child filter and join filter produces unexpected
results. I'll chase it up and post back when I've got
some more info, but if you look at the merge views, you
can see where the problem lies - there is a union
statement, and the filter only applies to one half of the
union.
Rgds,
Paul Ibison
|||Hi paul:
Firstly, do you mean it has a way to figure this problem out?
Secondly. where is merge views? is that a script of replication or
what?
Cheers
Nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:007701c535dc$9119c6b0$a501280a@.phx.gbl...
> Nick,
> what you've hit on is v.interesting and is something that
> I'll look into in more detail. A combination of parent
> filter, child filter and join filter produces unexpected
> results. I'll chase it up and post back when I've got
> some more info, but if you look at the merge views, you
> can see where the problem lies - there is a union
> statement, and the filter only applies to one half of the
> union.
> Rgds,
> Paul Ibison
>
|||Nick,
IMHO it is a bug.
If you have join filters, and static table filters on each table in the
join, the results are not filtered correctly, or at least not at all
intuitively.
eg, I have 2 tables: tParents and tChildren, joined by PK - FK relationship.
There is a filter clause on each table. The resulting (automatically
created) merge view for tParents is:
create view [ALNMerge_tParents_VIEW] as
select alias_A2E8A2147CA04D67BA17EF914868C4AA.* from [dbo].[tParents]
alias_A2E8A2147CA04D67BA17EF914868C4AA
where rowguidcol in ( select [tParents].rowguidcol from [dbo].[tParents]
[tParents] , [ALNMerge_tChildren_VIEW] [tChildren] where ( (
[tParents].[id] = [tChildren].[parentid]) ) and ({ fn
ISPALUSER('62E99837-892B-4157-82FF-793161691118') } = 1)
union
select [dbo].[tParents].rowguidcol from [dbo].[tParents]
where ( (tparents.id = 2) ) and ({ fn
ISPALUSER('62E99837-892B-4157-82FF-793161691118') } = 1) ) and ({ fn
ISPALUSER('62E99837-892B-4157-82FF-793161691118') } = 1)
The first part refers to the join, and the second refers to the filter, but
they are unioned, rather than the filter applying to each select. This means
that rows arriving as part of the join,
but which don't have an ID = 2 are returned!
Rgds,
Paul Ibison

Row filter

i got a really strange problem.
i am doing replication DB from SQL to PDA with CE2.0, there are about 30
articles in publication, and one of them is call product table. it works fine
when i add product table without row filter. the problem is when i add a
row filter in Product table , it occur error call "run".
product table has one primary key with identity.
so anyone know what's going on here?
cheers
nick
I understood that the problem is strange... But I can not say that I
understood what kind of error are you getting... Could you provide more info
on the error ?
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:BDB59813-A018-40B5-8894-26FD281F6831@.microsoft.com...
> i got a really strange problem.
> i am doing replication DB from SQL to PDA with CE2.0, there are about 30
> articles in publication, and one of them is call product table. it works
fine
> when i add product table without row filter. the problem is when i add
a
> row filter in Product table , it occur error call "run".
> product table has one primary key with identity.
> so anyone know what's going on here?
> cheers
> nick
>
|||could you script out your publication, schema, and post it here along with
the exact error message you are getting?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:BDB59813-A018-40B5-8894-26FD281F6831@.microsoft.com...
> i got a really strange problem.
> i am doing replication DB from SQL to PDA with CE2.0, there are about 30
> articles in publication, and one of them is call product table. it works
fine
> when i add product table without row filter. the problem is when i add
a
> row filter in Product table , it occur error call "run".
> product table has one primary key with identity.
> so anyone know what's going on here?
> cheers
> nick
>
|||i fixed this problem by tick the force relationship to replication option in
this table's relation property.
thanks all
nick

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 ******/