If you are trying to generate a standard trigger for each table, we wrote a VB program that does that.
It creates a script file to create a DELETE and UPDATE/INSERT trigger for each table in the database. The standard triggers updates the UserID & time of the update/insert, and inserts a record into an audit table for each change to the record. Then we modifiy the standard trigger for anything special that a particular table needs done.
I can send you the "guts" of the VB routing that generates the trigger. It would need some heavy modification to work for anyone else.