T-SQL query (on system tables) that what has changed in the database

select o.name, o.object_id, o.modify_date, c.text

from sys.objects o

join sys.syscomments c

on o.object_id = c.id