看看AutoAudit>

这会将列添加到表中并创建 DML 触发器来管理这些列以及维护审计跟踪表

我发现它非常有用

当然可以使用 DDL 触发器来尝试强制执行表设计问题.还可以自动检查元数据的设计气味

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?

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