Skip to main content
O
OldNapkin
Inspiring
May 11, 2006
Question

How to Track When a Record Gets Updated

  • May 11, 2006
  • 2 replies
  • 706 views
I'd like to be able to automatically store the date and time that a record gets updated in a SQL 2000 DB. I currently stamp the record when it's first created by having a field with a default value of GETDATE(), but I can't seem to find an easy way to track the updates.

Thanks!
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
May 11, 2006
Write a trigger.
P
paross1
Participating Frequently
May 11, 2006
To expand on Dan's post....

Phil
A
Anonymous
May 11, 2006
Why not create a field that contains the latest update date?
O
OldNapkinAuthor
Inspiring
May 11, 2006
I have a field - I'm looking for a function in the database to update the field with the date and time when the record gets updated. I know I could update it with a query from ColdFusion, but I'd like it all to just happen automatically within the DB.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices