This simple query tells us if there were any database objects created within the last 24 hours. You can modify the DATEADD parameters to get a larger time span.

select * from sys.objects where create_date > dateadd(D, -1, getdate())

This second query tells us if there were any database objects modified within the last 24 hours. You can modify the DATEADD parameters to get a larger time span.

select * from sys.objects where modify_date > dateadd(D, -1, getdate())