Posted by Erland Sommarskog on 03/01/07 22:08

Rayne (wifetalks@gmail.com) writes:
> I've come across this same issue...so I basically have to create a
> trigger for each table in my database to update the username/modified
> fields on each update. Is there a way to create a global update
> trigger that will fire when any table with those fields is updated?

No, but you could write a program to generate them.

You could also consider third-party tools ApexSql (www.apexsql.com)
has SQL Audit, for instance. I have not tried it myself.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]