Is there any way to find which table was recently modified (in terms of data) in SQL Server? For example, I am dealing with a badly written code which is very hard to debug, and in order to be able to find what is going on, I would like to create a record via that system and then query what has been changed in the database.

I came across this query

```
select schema_name(schema_id) as schema_name,
   name as table_name,
   create_date,
   modify_date
from sys.tables
where modify_date > DATEADD(DAY, -30, CURRENT_TIMESTAMP)
order by modify_date desc;

```

but it doesn't seem to give me what I need. As when I try to manually update and insert records in a table, this query still shows zero results.

I cannot enable the `CDC` feature on that database.