Rowguid Column Position

Hi,
We are merge replication more than 20 databases . Currently we added
one new column to a table so it will be added only in last, and now only in
this table the rowguid is not the last column.
I want to know because of this is there is any problem in replication.
Please give me a solution as soon as possible
thanks,
Soura
Soura,
the rowguid column doesn't need t be the last column, and sp_repladdcolumn
is all you need to use in this circumstance.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Rowguid Column at the end of my Tables

Hello,
There is a "rowguid" column that was added to the end of my tables, and I
have no clue when and why it was added. Actually i had a Merge Replication on
this database and i removed it. I don't know if it was generated by SQL
Server for Merge Replication or something else.
Ant idea ???
Thanks so much
Mathew
Matthew,
this column is essential (actually a column with the rowguid property) to
merge replication. Removing replication will not remove these columns -
you'll need to do it by hand or craft a script. Be sure however that the
developers haven't coded to include this column.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Dear Paul,
Thanks so much for your helps. I know how to remove this column either on
the Enterprise Manager or by scripts using sysobject to get the table name
and remove this column, but is there any easier ways or scripts that you know?
I appreciate so much.
Mathew
"Paul Ibison" wrote:

> Matthew,
> this column is essential (actually a column with the rowguid property) to
> merge replication. Removing replication will not remove these columns -
> you'll need to do it by hand or craft a script. Be sure however that the
> developers haven't coded to include this column.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

Rowguid - index in system table

Hi,
I am dealing with merge replication.
The missing statistics event points out [MSmerge_tombstone].[rowguid] in all
our databases. Noticed that no specific index for rowguid created in
[MSmerge_tombstone] table specific on this column.
We would like to know why there is no index created on this column.Do we
need to manually create this index?
Does this missing statistics is an indication of potential problem. If so
what could be the corrective action(s) ?
Thanks,
Soura
indexes are only used if the table is greater than 100 pages. This means
that if more than 1500 rows exist in your tombstone table it would benefit
for queries which are done on the rowguid column alone.
The most significant column in the queries is the generation column and also
on the tablenick and rowguid columns. There are indexes on these columns.
Which queries/procs are complaining about the missing statistics? Does
autocreate and auto update statistics help with the performance of this
database?
Also note that by default the metadata tables are cleaned up each time the
merge agent runs so they should be small.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SouRa" <SouRa@.discussions.microsoft.com> wrote in message
news:16760881-928B-4137-A542-D430C97ACC78@.microsoft.com...
> Hi,
> I am dealing with merge replication.
> The missing statistics event points out [MSmerge_tombstone].[rowguid] in
> all
> our databases. Noticed that no specific index for rowguid created in
> [MSmerge_tombstone] table specific on this column.
> We would like to know why there is no index created on this column.Do we
> need to manually create this index?
> Does this missing statistics is an indication of potential problem. If so
> what could be the corrective action(s) ?
> Thanks,
> Soura

Row operation cannot be reapplied

Hi,

I'm merge replicating between SQL Server 2005 and SQL Compact on mobile devices. This has been running reasonably well, after a lot of setup problems, but recently I've noticed an error when a new subscription synchronizes with the server (creating a new database on the device). After running for several minutes, the synchronization stops with the following error:

"The row operation cannot be reapplied due to an integrity violation. Check the publication filter. [Table = AppUser,Operation = Insert,RowGuid = ..."

There are no filters on the publication. The record causing the problem already exists on the server and is apparently being added to the new database on the subscriber, but it seems the merge agent is trying to add the record twice. I've tried doing a new snapshot and then immediately synchronizing, but still the same error. Has anyone come across this problem when synchronizing, especially with a new database/subscription?

Regards,

Greg

This error is created because of an integrity issue in you table schema. I had the same problem where I had created a foreign key relationship from one table to 2 fields in the joined table. For example:

My replication filtered on employee name (or HOST_NAME())

This employee table field existed in 2 fields of the joined table, ie: records could be sent to 2 subscriptions based on 2 fields in the record table which related to the employee table.

I had to delete the FK relationship in the database, and just kept the relationship in the filtered join in the replication. This solved the error.

|||

I encountered the problem too. Is the limitation of compact edition doesn't support FK relationship in the table?

Anyone had worked around the issue?

Jun

|||No, sql compact database supports fk relationships just fine. Replication, however, is very particular about the schema of the replicated tables. When setting up the replication be sure you know whether relationships are 1 to many, 1 to 1, or many to many. Any deviation from this will cause this or other errors. For example in my case I had 1 table FK relate to 2 fields in another table, although this schema can be fine in a normal production database, when replicated, it makes it hard for the replication to keep track of GUIDs and other replication objects. So I just deleted one of the relationships and kept the other.|||

I am having a very similar issue - how did you get the error message to include the actual table, guid, etc. My error message is as follows:

The row operation cannot be reapplied due to an integrity violation. Check the Publication filter. [,,,Table,Operation,RowGuid] (Source: MSSQLServer, Error number: 28549)

I have a filter using HOST_NAME() as well with your typical FK's 1 field in one table to 1 field in another.

I am under the gun to get this app out and I just can not get enough details on this error to resolve, any help would be greatly appreciated.

Thanks,
Daniel

|||Since your error is not specifying a certain table, you'll have to test it 1 relationship at a time starting with the main filter relationship. Drop the relationship in the production database, re-create snapshot and reinitialize subscriptions until you've removed the errored relationship. Then re-examine your schema to determine why the error happened and see if you can re-design the relationship. Good luck.|||

Wow, there is no way to turn on additional logging that would produce a more detailed error message?

Row operation cannot be reapplied

Hi,

I'm merge replicating between SQL Server 2005 and SQL Compact on mobile devices. This has been running reasonably well, after a lot of setup problems, but recently I've noticed an error when a new subscription synchronizes with the server (creating a new database on the device). After running for several minutes, the synchronization stops with the following error:

"The row operation cannot be reapplied due to an integrity violation. Check the publication filter. [Table = AppUser,Operation = Insert,RowGuid = ..."

There are no filters on the publication. The record causing the problem already exists on the server and is apparently being added to the new database on the subscriber, but it seems the merge agent is trying to add the record twice. I've tried doing a new snapshot and then immediately synchronizing, but still the same error. Has anyone come across this problem when synchronizing, especially with a new database/subscription?

Regards,

Greg

This error is created because of an integrity issue in you table schema. I had the same problem where I had created a foreign key relationship from one table to 2 fields in the joined table. For example:

My replication filtered on employee name (or HOST_NAME())

This employee table field existed in 2 fields of the joined table, ie: records could be sent to 2 subscriptions based on 2 fields in the record table which related to the employee table.

I had to delete the FK relationship in the database, and just kept the relationship in the filtered join in the replication. This solved the error.

|||

I encountered the problem too. Is the limitation of compact edition doesn't support FK relationship in the table?

Anyone had worked around the issue?

Jun

|||No, sql compact database supports fk relationships just fine. Replication, however, is very particular about the schema of the replicated tables. When setting up the replication be sure you know whether relationships are 1 to many, 1 to 1, or many to many. Any deviation from this will cause this or other errors. For example in my case I had 1 table FK relate to 2 fields in another table, although this schema can be fine in a normal production database, when replicated, it makes it hard for the replication to keep track of GUIDs and other replication objects. So I just deleted one of the relationships and kept the other.|||

I am having a very similar issue - how did you get the error message to include the actual table, guid, etc. My error message is as follows:

The row operation cannot be reapplied due to an integrity violation. Check the Publication filter. [,,,Table,Operation,RowGuid] (Source: MSSQLServer, Error number: 28549)

I have a filter using HOST_NAME() as well with your typical FK's 1 field in one table to 1 field in another.

I am under the gun to get this app out and I just can not get enough details on this error to resolve, any help would be greatly appreciated.

Thanks,
Daniel

|||Since your error is not specifying a certain table, you'll have to test it 1 relationship at a time starting with the main filter relationship. Drop the relationship in the production database, re-create snapshot and reinitialize subscriptions until you've removed the errored relationship. Then re-examine your schema to determine why the error happened and see if you can re-design the relationship. Good luck.|||

Wow, there is no way to turn on additional logging that would produce a more detailed error message?

Row filtering - Comparing HOST_NAME() with uniqueidentifier

Working with Merge Replication between SQL Server 2000 and SQL Server
CE 2.0.
I was doing some filtering on the Publication with "host_name()"
function. I was comparing host_name() function with a nvarchar column,
so all was working pretty well.
In order to filter all appointments for a specific patient, I was
trying to assign the HostName property of the replication object with
patientId. This patientId is a uniqueidentifier column, therefore, when
building the where clause condition in the Publication's properties
(patientId = HOST_NAME()), I got an error saying that cannot compare
varchar with uniqueidentifier.
Any solution to this? I think I should compare the uniqueidentifier
column rather than adding another nvarchar column
(patientId2)containing same value as patientId original column?
Besides: I need a patient only can see his/her appointments, but that a
doctor can see all appointments from all his patients. Appointment
table contains doctorId and a patientId fields, which both have
uniqueidentifier datatype.
What should be the best filter for this case? Would I need another
publication or a gool filter would done it?
Thanks in advance.
have a look at fn_varbintohexstr.
For the second one it sounds like you need a second publication where you
filter on the doctorID.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lonifasiko" <mloichate@.gmail.com> wrote in message
news:1128333296.020256.272540@.g44g2000cwa.googlegr oups.com...
> Working with Merge Replication between SQL Server 2000 and SQL Server
> CE 2.0.
> I was doing some filtering on the Publication with "host_name()"
> function. I was comparing host_name() function with a nvarchar column,
> so all was working pretty well.
> In order to filter all appointments for a specific patient, I was
> trying to assign the HostName property of the replication object with
> patientId. This patientId is a uniqueidentifier column, therefore, when
> building the where clause condition in the Publication's properties
> (patientId = HOST_NAME()), I got an error saying that cannot compare
> varchar with uniqueidentifier.
> Any solution to this? I think I should compare the uniqueidentifier
> column rather than adding another nvarchar column
> (patientId2)containing same value as patientId original column?
> Besides: I need a patient only can see his/her appointments, but that a
> doctor can see all appointments from all his patients. Appointment
> table contains doctorId and a patientId fields, which both have
> uniqueidentifier datatype.
> What should be the best filter for this case? Would I need another
> publication or a gool filter would done it?
> Thanks in advance.
>
|||Thanks Hilary.
I'll take a look at that function.
Respecting to my second request, my initial idea was to only have one
publication for all the application instead of having several and
having to mantain them. Does it worth or is the normal approach to have
more than one publication? Isn't there another way of achieving what
I'm looking for? I would prefer to have only one publication, but if
there is not another way.......
Regards.
|||I would go for multiple publications. There is more administrative effort,
but slight.
You might be able to get away with a more complex filter, is something along
the line of
<> where PatientID in (select patientID from patients where something = case
when HOST_NAME() > 'M' then (select doctorID from doctors) else
host_name()end )
So you could build an elaborate case statement and do existence checks with
subqueries, or even use UDF's, but you are limited by what you can do on the
host end which is CE, and then there will be a performance hit while this
where condition is evaluated.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lonifasiko" <mloichate@.gmail.com> wrote in message
news:1128341002.180658.194500@.g43g2000cwa.googlegr oups.com...
> Thanks Hilary.
> I'll take a look at that function.
> Respecting to my second request, my initial idea was to only have one
> publication for all the application instead of having several and
> having to mantain them. Does it worth or is the normal approach to have
> more than one publication? Isn't there another way of achieving what
> I'm looking for? I would prefer to have only one publication, but if
> there is not another way.......
> Regards.
>
|||I see your example too complex to build. Besides, I'm not sure I
understand your "where clause" example. What about when HOST_NAME() >
'M' ? Sorry but I don't understand it at all. Could you give me a
little more detailed example, with pseudo-code or something similar
please?
You mean you can elaborate case statements in the Publication's where
clause? And can I include subqueries and so on?
I understand UDF's are difficult when working against SQL Server CE,
aren't they?
I cannot achieve to convert host_name() to uniqueidentifier.
Publication's property page tells me cannot do that. Any example?
The alternative of RDA would be useful in this case?
Sorry to ask you for all kind of examples Hilary but I've never
experienced with Merge Replication before?
|||Hi again Hilary, I've achieved what I was looking for with the row
filtering I show you below. Don't know if it's good for performance or
not, but works great and I think meets my requirements. Anyway, any
opinion or new idea will be greatly appreciated:
SELECT <columnas_publicadas> FROM [dbo].[Appointment] WHERE
patientId in
(select patientId from Patient where patientFirstName = HOST_NAME())
or doctorId in
(select doctorId from Doctor where doctorFirstName = HOST_NAME())
This is a non-real "where clause", because it's not very useful to
filter rows based on the first name of the patient or doctor. Anyway,
in this case, I fill the Replication object's HostName property with
patient's or doctor's first name and the "OR" clause works great for
me! I understand that when patientId is not found, doctorId is checked.
If patientId is found, doctorId is not checked anymore.
I now would like to achieve the same with uniqueidentifiers but I'm not
able.
Is it better to have two publications for this case, or with this "OR
where clause" would be enough?
Thanks very much. I'm willing for any reply or advice.
|||basically its something bogus, but something I use every once and a while.
Host_name() >'m' compares this first value of host_name and checks to see if
its ascii value is greater than the ascii value of m.
so a host_name of 'alpha' would not meet this filtering criteria, whereas a
host_name of 'nancy' would. You can override the host_name() value by using
the -HostName parameter in your command string.
I can't really elaborate on the possible where clause or a case statement as
I don't know your schema. It looks like you are filtering on patients by
patientID. Note that you could issue a subquery if you have a doctor's table
of if the patients table is related to the doctor table via dri and you
extend the join filter it should work automatically.
I was hoping you would look at what I had written and go ah ha!
Can you post the schema of the doctors/patients tables?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lonifasiko" <mloichate@.gmail.com> wrote in message
news:1128343662.941267.220180@.f14g2000cwb.googlegr oups.com...
> I see your example too complex to build. Besides, I'm not sure I
> understand your "where clause" example. What about when HOST_NAME() >
> 'M' ? Sorry but I don't understand it at all. Could you give me a
> little more detailed example, with pseudo-code or something similar
> please?
> You mean you can elaborate case statements in the Publication's where
> clause? And can I include subqueries and so on?
> I understand UDF's are difficult when working against SQL Server CE,
> aren't they?
> I cannot achieve to convert host_name() to uniqueidentifier.
> Publication's property page tells me cannot do that. Any example?
> The alternative of RDA would be useful in this case?
> Sorry to ask you for all kind of examples Hilary but I've never
> experienced with Merge Replication before?
>
|||I don't know if you've read my last post. I suppose yes. I've achieved
this way, with a where clause containing an OR:
SELECT <columnas_publicadas> FROM [dbo].[Appointment] WHERE
patientId in
(select patientId from Patient where patientFirstName = HOST_NAME())
or doctorId in
(select doctorId from Doctor where doctorFirstName = HOST_NAME())
I understand you don't agree with this approach at all but as I've
already told you, I want to avoid having more tha one publication. How
do you see it?
My database schema goes as follows:
Table Patient: patientId (uniqueidentifier -PK), patientFirstName, etc.
Table Doctor: doctorId (uniqueidentifier -PK), doctorFirstName, etc.
Relation table - Table DoctorPatient: patientId (part of PK), doctorId
(part of PK), diseaseId(part of PK), rowguidcol (generated by the
Publication) and so on.
Note that a patient can have same doctor for different diseases. For
example: Patient A is attended by Doctor B for disease C, and Patient A
is also attented by Doctor B, this time for disease D.
Anyway, I cannot filter directly by GUID, that is, I cannot convert
host_name() to GUID!
Help me please!
I hope to have explained myself correctly enough. Really thanks for
your time Hilary.Regards.
|||Hi again Hilary,
My "final" where clause would be as follows:
SELECT <columnas_publicadas> FROM [dbo].[Appointment] WHERE
HOST_NAME() = convert(nvarchar(100), patientId) or HOST_NAME()
= convert(nvarchar(100), doctorId) and isClosed = 0
You can notice that I am now able to do the comparison between
uniqueidentifier and nvarchar. I thougth this comparison had to be done
in the other direction, but found this and worked. Would be better to
convert host_name() to uniqueidentifier or left it this way?
I've also noticed that this where clause consumes additional time. I
didn't expect, but this way the first replication delays in some
seconds respect an initial replication wihout where clauses. Is this
normal? Could be because I now haven't got many rows while this
attempts are being done?
Give me some feedback please. Regards.
|||This looks ok. I think you would be better off adding an int column to the
doctor and patient tables. Add the identity property to these columns, put
an index on them and then use these in your join condition. It will be more
efficient this way.
Other than that try to put an index on the unique identifier column to speed
up the queries.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lonifasiko" <mloichate@.gmail.com> wrote in message
news:1128433459.393363.244450@.g14g2000cwa.googlegr oups.com...
> Hi again Hilary,
> My "final" where clause would be as follows:
> SELECT <columnas_publicadas> FROM [dbo].[Appointment] WHERE
> HOST_NAME() = convert(nvarchar(100), patientId) or HOST_NAME()
> = convert(nvarchar(100), doctorId) and isClosed = 0
> You can notice that I am now able to do the comparison between
> uniqueidentifier and nvarchar. I thougth this comparison had to be done
> in the other direction, but found this and worked. Would be better to
> convert host_name() to uniqueidentifier or left it this way?
> I've also noticed that this where clause consumes additional time. I
> didn't expect, but this way the first replication delays in some
> seconds respect an initial replication wihout where clauses. Is this
> normal? Could be because I now haven't got many rows while this
> attempts are being done?
> Give me some feedback please. Regards.
>

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

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