Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2000 - DateTime of Row Insert/Update?
Message
From
06/08/2003 19:13:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Server 2000 - DateTime of Row Insert/Update?
Miscellaneous
Thread ID:
00817505
Message ID:
00817505
Views:
74
A client wants to track when table rows in a SQL2K database are initially INSERTed, or UPDATEd later. My first thought was to add a datetime column, and create trigger(s) that update its value appropriately.

Then I thought, maybe this is something SQL Server tracks automatically, and could maybe be accessed with a system stored procedure call or ?.

I'm not a SQL2K expert, so any advice or ideas appreciated. However, I don't anticipate investing in a SQL Server audit product at this point as it doesn't look (yet) like there's either the need, or budget, for anything that sophisticated. TIA.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Next
Reply
Map
View

Click here to load this message in the networking platform