Querying Modification Dates for a Table

[Middlej]

I would like to be able to query table modification dates to see when a user table has been modified. For example, if I want to see when an INSERT statement has been performed on a specific user table, can I query for this in the system tables? The benefit here is to be able to effectively audit system updates.

Thank you

 

[JayKusch]

Don't believe that is possible unless you have some type of datetime field w/in your table that logs changes/additions via a trigger.

Thanks

J. Kusch