Re: writing audit trail for a table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Troxell (steve_troxell_at_hotmail-nospamforme.com)
Date: 03/01/05 

Date: Tue, 01 Mar 2005 11:52:14 -0500

Sa wrote:
> That's what I guess. I just wondering is there a better way to do. It is
> because there are many fields in the table.

Depends on how long it takes you to hand-code the trigger, and deal with
any future changes, or devise a script or program to generate the
trigger based on system table data. This compared to spending a little
money for a third-party tool which does the job in a couple of minutes.

Steve

Relevant Pages

  • Re: Trigger
    ... Oh Steve, I absolutely split my sides laughing when I read your reply :-) My husband asked me what had I been writing on the News Group! ... > Trigger is a feature introduced in PowerPoint XP / 2002 and the later ... > the Slide Show is clicked, hence triggering the animations. ...
    (microsoft.public.powerpoint)
  • RE: Oracle and dbh -> last_insert_id
    ... To: List - DBI users ... Hi Steve ... invocations of nextval in trigger logic fired from your insert. ... # populate SomeTable.ID_Column ...
    (perl.dbi.users)
  • Re: Trigger status
    ... > Tibor Karaszi, SQL Server MVP ... >> Is there a way that I can get the Enabled status of a trigger in my ... >> Kind regards, ... >> Steve. ...
    (microsoft.public.sqlserver.programming)
  • Re: Mavericks surf contest is on for Saturday
    ... I may be interested in sharing a ride. ... Steve I'm not going. ... I think the Organizers pulled the trigger to ...
    (rec.windsurfing)
  • Re: through VB code ??
    ... "Steve K." ... > other machine on a LAN? ... > like how would i go if i am sitting on machine-A and i want to trigger ... There are also products sold for this sort of thing such as WTS, Citrix, PC ...
    (microsoft.public.vb.general.discussion)