We walk in the dark places no others will enter
We stand on the bridge and no one may pass

--make a couple of test tables
if exists (select 1 from sys.tables where name = 'DataMod') drop table dbo.DataMod
go
if exists (select 1 from sys.tables where name = 'DataTest') drop table dbo.DataTest
GO
create table dbo.DataMod([schema] sysname, name sysname, modify_date datetime)
go
create table dbo.DataTest(TestCol1 int identity)
go
-- build a trigger to store off whenever the data is changed on the table
CREATE TRIGGER [trg_data_test] ON dbo.DataTest for update, insert, delete AS
insert into dbo.DataMod select 'dbo','DataTest', GetDate()
GO
-- show when the table was created and modified
select name, create_date, modify_date from sys.tables where object_id = object_id('dbo.DataTest')
GO
-- add three records
insert into dbo.DataTest DEFAULT VALUES
GO 3
-- add a new column to the table
alter table dbo.DataTest add TestCol2 uniqueidentifier default newid()
GO
-- show that the table was modified
select name, create_date, modify_date from sys.tables where object_id = object_id('dbo.DataTest')
GO
-- add three more records
insert into dbo.DataTest DEFAULT VALUES
GO 3
-- show that the data was added, and that the table that stores when the table was last modified has been added
select * from dbo.DataTest
select * from dbo.DataMod
GO

select 
db_name(database_id) dbname,
object_name(object_id,database_id) oname,
MAX(CASE WHEN last_user_update < last_system_update THEN last_system_update ELSE last_user_update END) as LastUpdated 
from sys.dm_db_index_usage_stats 
group by database_id,object_id
order by db_name(database_id),object_name(object_id,database_id)