How to track when a row was created/updated automatically in SQL Server?

sql-server, t-sql

Solution

Have a look at AutoAudit

This will add columns to a table and create DML triggers to manage those columns as well as maintain the audit trail table

I've found it to be very useful

It's certainly possible to use DDL triggers to attempt to enforce table design issues. It's also possible to automate checking the metadata for design smells

Problem

Is there a way to automatically tell SQL Server that all tables should have a timestamp for insert and update? That's probably a lot of repetitive work to do this? Or is there another/more efficient way to do this with the transaction log?

Original source