I want to create a loop using SQLDMO that will create a standardized trigger for each table (in a specific SQL Server database) that will
1. keep track of who last changed the record
2. keep track of when the last record was changed.
3. record the previous information in a history table
I am not familiar with how to create a trigger programmatically. I would assume that i have 2 choices--