[dba-SQLServer] Audit Trails

An effecient way is to create a trigger on table UPDATE. Using the trigger 
table "inserted" you can gain the newvalue you are seeking.

On 5/11/05, Joe Rojas <JRojas at tnco-inc.com> wrote:
> 
> Hi All,
> 
> How can I go about creating audit trails for a table in SS7.5?
> 
> What I would like to be able to see is if a user updates a row I could 
> see:
> EmpID
> DateChanged
> ColumnName
> OldValue
> NewValue
> 
> Thanks!
> JR
> 
> This electronic transmission is strictly confidential to TNCO, Inc. and
> intended solely for the addressee. It may contain information which is
> covered by legal, professional, or other privileges. If you are not the
> intended addressee, or someone authorized by the intended addressee to
> receive transmissions on behalf of the addressee, you must not retain,
> disclose in any form, copy, or take any action in reliance on this
> transmission. If you have received this transmission in error, please 
> notify
> the sender as soon as possible and destroy this message. While TNCO, Inc.
> uses virus protection, the recipient should check this email and any
> attachments for the presence of viruses. TNCO, Inc. accepts no liability 
> for
> any damage caused by any virus transmitted by this email.
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...