Obtendo a última data de alteração de cada tabela

TablesLastUpdates.sql

SELECT
  q.tableName
  ,MAX(q.lastUpdate) AS lastUpdate
FROM
(
  SELECT
    s.name + '.' + t.name AS tableName
    ,ISNULL(u.last_user_update, '2000-01-01') AS lastUpdate
  FROM sys.tables AS t
  INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id
  LEFT JOIN sys.dm_db_index_usage_stats AS u ON u.object_id = t.object_id
) q
GROUP BY q.tableName