Re: Identity Column - transactional replication with immediate update

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 20:52:44 +0100

Thomas,
the only way I can reproduce this behaviour is if there is an insert trigger
on the publisher's table which updates the same row.
In this case the guids won't match.
Can you check if this is the case?
Rgds,
Paul Ibison

Relevant Pages

  • Re: tracking Update, insert, delete during/after replication
    ... (transactional replication) ... Will a trigger perform ok on large sets of updates? ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: SQL BEFORE puzzle
    ... hanging out here who is able to speak with authority on SQL. ... be prevented from doing any updates. ... "If the trigger is a BEFORE trigger and if, ... beforeT: update T .... ...
    (comp.databases.theory)
  • Re: NFS Locking Issue
    ... to am-utils running into some race condition the other problem is related to throughput, freebsd is slower than linux, and while freebsd/nfs/tcp is faster on Freebsd than udp, on linux it's the same. ... If you can help to produce simple test cases to reproduce the bugs you're seeing, ... First, architectural issues, some derived from architectural problems in the NLM protocol: for example, assumptions that there can be a clean mapping of process lock owners to locks, which fall down as locks are properties of file descriptors that can be inheritted. ... Once you've established whether it can be reproduced with a single client, you have to track down the behavior that triggers it -- normally, this is done by attempting to narrow down the specific program or sequence of events that causes the bug to trigger, removing things one at a time to see what causes the problem to disappear. ...
    (freebsd-stable)
  • Re: SQL BEFORE puzzle
    ... hanging out here who is able to speak with authority on SQL. ... be prevented from doing any updates. ... "If the trigger is a BEFORE trigger and if, ... beforeT: update T .... ...
    (comp.databases.theory)
  • Re: Need advise about an application
    ... statistics generation can use the rest of the time, ... test/return) you should get back to other GUI events in time for screen ... updates, and without running into the start of the next timed check. ... signal from the device could have a function as a trigger. ...
    (comp.lang.python)