Find tables with modified data after a specified datetime
You can use something like

    SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables


you can add a WHERE clause to limit the results to only those changes that have occurred in the past week, month, year, whatever. Something like

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.views
WHERE
        modify_date &gt; DATEADD(day,-30,GETDATE())


Although this is no substitute for true database auditing that captures who modified the table, what was changed, and what the table looked like prior to the change.

To get the former, you'll need to invest some time in DDL triggers or some money into a third party tool.