Here are a couple of links which may be of use...
http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html
http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.