Hi,
I would like to know if we can check merge replication conflicts
programmatically.
which tables do we need to check for replication conflicts?
By default some conflict_* tables are created. will these contain the
info?
Rgds,
amit
mitsql,
yes the conflict_ tables contain the necessary information. In detail
they contain the column values of the losing replication partner plus
the reason for the conflict and the guid. If you want to be notified
when a conflict occurs you can create an insert trigger on the conflict
tables which either sends a mail or runs some sript/store procedure.
Markus
sql
Showing posts with label programmatically. Show all posts
Showing posts with label programmatically. Show all posts
Tuesday, March 27, 2012
check replication conflicts programmatically
Hi,
I would like to know if we can check merge replication conflicts
programmatically.
which tables do we need to check for replication conflicts?
By default some conflict_* tables are created. will these contain the
info?
Rgds,
amitmitsql,
yes the conflict_ tables contain the necessary information. In detail
they contain the column values of the losing replication partner plus
the reason for the conflict and the guid. If you want to be notified
when a conflict occurs you can create an insert trigger on the conflict
tables which either sends a mail or runs some sript/store procedure.
Markus
I would like to know if we can check merge replication conflicts
programmatically.
which tables do we need to check for replication conflicts?
By default some conflict_* tables are created. will these contain the
info?
Rgds,
amitmitsql,
yes the conflict_ tables contain the necessary information. In detail
they contain the column values of the losing replication partner plus
the reason for the conflict and the guid. If you want to be notified
when a conflict occurs you can create an insert trigger on the conflict
tables which either sends a mail or runs some sript/store procedure.
Markus
check replication conflicts programmatically
Hi,
I would like to know if we can check merge replication conflicts
programmatically.
which tables do we need to check for replication conflicts?
By default some conflict_* tables are created. will these contain the
info?
Rgds,
amitmitsql,
yes the conflict_ tables contain the necessary information. In detail
they contain the column values of the losing replication partner plus
the reason for the conflict and the guid. If you want to be notified
when a conflict occurs you can create an insert trigger on the conflict
tables which either sends a mail or runs some sript/store procedure.
Markus
I would like to know if we can check merge replication conflicts
programmatically.
which tables do we need to check for replication conflicts?
By default some conflict_* tables are created. will these contain the
info?
Rgds,
amitmitsql,
yes the conflict_ tables contain the necessary information. In detail
they contain the column values of the losing replication partner plus
the reason for the conflict and the guid. If you want to be notified
when a conflict occurs you can create an insert trigger on the conflict
tables which either sends a mail or runs some sript/store procedure.
Markus
Labels:
conflicts,
conflictsby,
conflictsprogrammatically,
database,
merge,
microsoft,
mysql,
oracle,
programmatically,
replication,
server,
sql,
tables
Saturday, February 25, 2012
chart y-axis scales
Hi,
How is it possible to programmatically set the min and max scale values of
the Y-axis in a chart?
Currently I manually enter values in the Y-Axis scale min/max properties.
ThanksJust place the field data into the boxes.
i.e. min(fields.id.value)
"farshad" wrote:
> Hi,
> How is it possible to programmatically set the min and max scale values of
> the Y-axis in a chart?
> Currently I manually enter values in the Y-Axis scale min/max properties.
> Thanks
How is it possible to programmatically set the min and max scale values of
the Y-axis in a chart?
Currently I manually enter values in the Y-Axis scale min/max properties.
ThanksJust place the field data into the boxes.
i.e. min(fields.id.value)
"farshad" wrote:
> Hi,
> How is it possible to programmatically set the min and max scale values of
> the Y-axis in a chart?
> Currently I manually enter values in the Y-Axis scale min/max properties.
> Thanks
Subscribe to:
Comments (Atom)