I can see how to identify what has changed using Change Tracking, but is there a way to determine the date of the change?

Basically, all I really need is a date and time of of the most recent change to a record. I had a trigger on the table that did this, but I wanted to replace it with Change Tracking thinking it would have better performance.

Also, my prior trigger checked to make sure that something has actually changed changed on the record prior to updating the time stamp by using a checksum on the row, which made it slower, but insured that if some massive update was run on all records, but didn't actually change any data then the time stamp wouldn't be updated.

Looks like this functionality is available through "Change Data Capture". Although it doesn't appear to care if a value was updated to the same value - it is transaction based and will capture all transactional changes. Looks like with CDC you can compare values though. I haven't used it yet but looks pretty robust at first glance.

Hi malachi151,I have been doing this from a long time. I am in the same tracking company. You can take a look at our s/w or any other help required I will be happy to help you.Thankshttp://www.labortimetracker.com/features.cfm