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.