Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 12th, 2007, 02:36 PM
Authorized User
 
Join Date: Aug 2004
Posts: 38
Thanks: 0
Thanked 0 Times in 0 Posts
Default tracking field updates

I want fields audited as well as the entire table. for example if someone enters data into a field, closes out of the database then goes back in and edits that field they want an indicator to tell them when and what time did they do that. Does that make sense??? I was trying to find a date function I could use to do that

The database I am using is SQL Server 2005 with an Access 2003 front end


 
Old September 12th, 2007, 08:28 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

You could use table triggers to check for updated values and write a record to an audit table. The trigger could test for change to each individual column so you could get very specific.

-Peter





Similar Threads
Thread Thread Starter Forum Replies Last Post
Tracking My mileage rkellogg VB How-To 2 September 6th, 2006 11:19 PM
Tracking who is changing what? rrhandle SQL Server 2000 1 August 15th, 2006 03:03 AM
Tracking Users arimakidd Classic ASP Professional 0 August 17th, 2005 05:35 PM
UPS Tracking jafarsalam XML 0 October 20th, 2004 04:23 PM
SESSION tracking natmaster Beginning PHP 1 August 18th, 2003 01:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.