History tables pros, cons and gotchas - using triggers, sproc or at application level [closed] History tables pros, cons and gotchas - using triggers, sproc or at application level [closed] database database