1. For Tables structural change
IF OBJECT_ID('tempdb..#lastaccess1') IS NOT NULL
DROP TABLE #lastaccess1;
CREATE TABLE
#lastaccess1(
[DBName]
sysname,
[TableNames] NVARCHAR(256),
[create_date] datetime,
[modify_date] datetime,
)
DECLARE @Statement1 VARCHAR(4000)
SET @Statement1 = 'USE [?]
SELECT
''?'' as [DBNAME], [TableName] =
name,
create_date, modify_date
FROM
sys.tables
ORDER BY modify_date DESC'
INSERT INTO #lastaccess1([DBName] ,[TableNames]
,[create_date],
[modify_date] )
EXEC sp_MSforeachdb @Statement1;
SELECT * FROM #lastaccess1 WHERE
[DBNAME] not in ('master', 'msdb','model','tempdb');
DROP TABLE #lastaccess1;