• Lawrence.

    It always goes back to the same question, what do we need to accomplish? In some cases CHECKSUM might be a valid option, (I am having a hard time coming up with an example in its favor, but that has more to do with the index scan than the symmetric update issue.) but there might be scenario's where this is a valid solution, as triggers might do the trick for (probably most) other people.

    I was merely pointing out that the standard audit columns would alleviate the symmetric update problem, I for one still would use triggers.

    Again, I do appreciate you taking the time you took, and sharing your stuff with us!

    Hans