RE: Removing updated and inserted data at subscriber after sync

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Charles,

Thanks for replying.

No, I do not want the behavior you mentioned.

I have a custom conflict resolver. Which based on certain rules rejects
subscriber's changes. This rejection part is working fine. No issues. In
addition to this what I want is these records rejected records (INSERT /
UPDATE / DELETE) should revert back.

What it mean is if subscriber has done INSERT which has been rejected then
this should be DELETED.
If DELETE record has been rejected then this particular record should be
INSERT back.
Any UPDATE has been rejected then it should rollback and origin data should
be updated.

Hope I am able to convey what I am looking for. Please let me know if
further information is required.
--
Thanks and Regards,
Prafull

""Charles Wang [MSFT]"" wrote:

Hi Prafull,
Did you mean that you only allow your subscriber to accept INSERT/UPDATE/DELETE from publisher and
that reject all INSERT/UPDATE/DELETE from the subscriber itself? In other words, if there are adding
records or deleting records happen on your publisher, the subscriber also need to
INSERT/UPDATE/DELETE those records, however if there are INSERT/UPDATE/DELETE operations
intiatively started by subscriber, that is not allowed, right?

I am afraid that there is no elegant way to implement this requirement. One method I can think is that
you may create an instead trigger for INSERT/UPDATE/DELETE on the table and within the trigger,
ensure that only the merge agent account is allowed to INSERT/UPDATE/DELETE data on the table. You
can judge this by using the function USER_NAME(). If USER_NAME() does not equal to the merge agent
account name, just return and your table will not be changed.

Please feel free to let me know if you have any other questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================






.

Relevant Pages

  • Re: Why do some people vote Democrat, especially Hollywood?
    ... support of the recently passed health insurance law and with your rejection ... The proof is in your support of your suggestion that didn't ...
    (rec.arts.movies.current-films)
  • Re: Why do some people vote Democrat, especially Hollywood?
    ... support of the recently passed health insurance law and with your rejection ... The proof is in your support of your suggestion that didn't ...
    (rec.arts.movies.current-films)
  • Re: proof that most etymologies are only fairy-tales
    ... Non sequitur. ... No one denies the theory that solar energy can be used as a source of power, so it isn't relevant to your claim about the rejection of new ideas. ... Your ideas are being rejected because you have no data to support them and, further, continue to demonstrate that you don't understand what is required to support such claims as those that you make. ...
    (sci.lang)
  • Re: BBC the creationist at the museum
    ... [SNIP] ... have no evidence to support your claim. ... for your rejection of it yourself. ...
    (talk.origins)