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

• Next in forum: Re: Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!
• Prev in forum: Re: Does anyone use SSIS for database schema maintenance?
• Thread view: Re: Newbie: Updating record with User information

[Reply to this message]