Sample Trigger to Create Audit History
You often want an automated audit of all or selected columns from a table. A trigger provides an easy way to do that. Then, when someone makes a change in a VB program, a C# program, Query Analyzer, Enterprise Manager, or anywhere else, the audit info is ALWAYS stored by the SQL Server itself (rather than relying on coding procedures).
