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.
--sb--