Find tables with modified data after a specified datetime I am performing few inserts and updates on my database using tool provided by app supplier. I want to compare the updated database and backup after running the tool.

But my database size is around 250GB, that takes long time to compare. Rather than full database compare I want to compare the tables which are modified after running the tool.

How can I get all the table names those are modified after specified date like 2015-04-14?

Can someone help me with this please?
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.