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

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.

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/2809/" >SQL Server 2000: Is there a way to tell when a record was last modified?< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.