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.