• I agree we have to view the problem from the clients perspective. Its a skill I pride myself on.

    Can I just whinge about the link to the updateable snapshot?

    What's wrong with updating the base table and then regenerating the snapshot? This is a far better solution than updating the base table and reading some data from the snapshot and some from the original database as proposed in the article. :sick: The approach discussed in the article leads to data inconsistencies.

    IMHO

    We are the pilgrims, master.
    We shall go always, a little further.