I am trying to find the last date and time that a snapshot updates to a table. How do I find that information?
What I want to do is create a trigger that runs after the table has been updated. I'm looking for a date/time field that the snapshot creates, any information will help.

tia

(thanks in advance)