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.
will that tell me when the table was last updated? What new entries were put into the table?
I'm lookign for a date/time on the table
that can be queried to run a trigger against. Are you saying that I should try to run
the trigger after the snapshot?