>Hi Al,
>
>There's no such built-in fetaure in SQL Server. For Inserted you can use default value GETDATE() and for Updated create a trigger.
>
>>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.
Thanks, Sergey.
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