SQL Server 2000: Is there a way to tell when a record was last modified?

Question

The table doesn't have a last updated field and I need to know when existing data was updated. So adding a last updated field won't help (as far as I know).

Answer 1

SQL Server 2000 does not keep track of this information for you.

There may be creative / fuzzy ways to guess what this date was depending on your database model. But, if you are talking about 1 table with no relation to other data, then you are out of luck.